Power Automate Search
Search
Condition step receiving wrong value from Get Changes for an Item or File
CommunityI have written a flow that is supposed to check for changes in a SharePoint list (an IT job ticketing list, as it happens), and send an email to the ticket creator if the ticket has been assigned -- ...
Re: Word Template flow runs successfully, but there is not data in the repeating sections
CommunityOk, so i found the issue. Posting the solution here for reference. The variables defined in the "Select" step did not match the title of the content control in the Word Template. ...
Re: Problem with HTML Trigger
CommunityHi @v-litu-msft , Thanks a lot for your reply. I am using the html in a button on my power BI report. Same way, how would I be able to put the above manual flow...
Receive an email from Excel every time a value is reached
CommunityHello everyone, I hope this topic is not opened somewhere else. How can an Excel file send an email with power automate when a certain value is reached in a table ? We have an Excel file (on Sh...
Update Project Level Custom field in Project Online
CommunityHi, I am trying to update project level custom field which is of type text and other of type flag. I am using power automate send http request to SharePoint trigger. Help me to over come this issue....
Re: Flow run failed: Unable to process template language expressions for action
CommunityWhich action in your flow throws the error? Your screenshot is so compressed it really isn't readable.
Re: "The execution of template action 'Switch' failed" error when using a switch case
CommunityThanks for your reply. What do you mean by 'simple value'? I am passing the underlying text value that the end-user would see on the form. What other value can I give it, or how can I convert the v...
Re: Save extracted Email Data to Excel
CommunityHere is a simple way to do this using Office Scripts. It will require the addition of an Office Script to Excel online and calling Run Script action within Excel online flow. The scrip...
Re: How can I clear a Sharepoint list Hyperlink column from Power Automate
CommunityBeing that I need to use variables, is there anyone that can provide a direction to help me address this issue?
Re: Populate Word Template: How to use dynamic files (dynamicFileSchema)
CommunityI'm using a static OneDrive for business location. Only my file name is dynamic. Could you show me how you constructed your variable?
Re: Dynamic Content - Null
Community@JoeHump Hey there. This might be a bit of a stretch, but I don't like to leave anything to assumptions: Are we certain that the rows are part of the table? I've seen it where u...
Approval continue but without outcome and response
CommunityI can't figure out why Action Approval (Start and wait for approval) will continue but no response and outcome, I also checked CDS msdyn_flow_approvalresponse , I can find the approval id in Req...
Re: Filter query on "Two options" field not working
CommunityHello @CRMPowerapps It's not possible to use a Multiselect option set field in an OData expression. Therefore you have two options: 1) Use the "filter array" action after list...
Re: How to take out [ ] in a string?
CommunityHi Pailie78, I am so sorry for missed that step, I though 👍 only this one. I just did. once again thanks for help me fixing the issue quickly. 🙂
Re: Concurrency issue
Community@shravanvijay Here is a link to the documentation on child Flows Here is a link to a video that will get you started Give it a try!
Change or replace text to NUMBER when copying input (text likert scale) from Forms to excel
CommunityI have a likert scale forma survey. I already automated it to get the data into an excel table on Onedrive. The title of likert scale is text: agree, strongly agree, etc (5scale). strongly agree=5...
Re: Wildcards in e-mail
Communityi'm surprised that this isn't available. I've created a flow in which I want to save on a e-mail only the e-mails from outside companies, however with the way the work is set the Inbox also contains ...
Connect As not connecting as service account
CommunityI've got an Excel step in my Power Automate Flow which accesses an Excel file on SharePoint and gets a row. I've changed the connection to use a service account so I don't have to grant everyone acce...
Corrupted attachements in list when added from email flow
CommunityHello everybody, I am building a flow that adds an item to a SharePoint list when an email arrives in a shared mailbox. The flow mostly works but I have an issue with attachments, they get a...
click web elements with xpath or css selector
CommunityHi, I have been trying to use the javascript for web functions function for clicking web elements. For our current project we are unable to get some of the web elements we need using the ...
Re: Updating excel column - how to move to next cell down ?
CommunityHi, yes, that was the fault. My set var was mistakenly in the loop so kept resetting. I assume the set/increase variable is the best way to update each row in say an excel file.
Re: Turn on Out Of Office option on Outlook with a flow
CommunityThank you , I will try it again and I will report back in case someone else needs something similar.
Re: Turn on Out Of Office option on Outlook with a flow
CommunityHi @Lympe13, That automatic reply should also work for Teams. However, sometimes there is a bit of a delay between setting the OoO reply in Outlook and seeing it in Microsoft Teams. &n...
Reorder Capabilities for Create CSV Table
CommunityThere appears to be no way to reorder columns when using the Create CSV Table action. The current method is to delete existing rows and add new rows if the order needs to be changed, which is tedious...
Re: How do I reference a custom file path in excel?
CommunityHi @xlzs, a custom path cannot be used in this scenario. The Excel connector actually uses the table ID and not the table name to identify the table that it needs to connect to. You can connect ...