Hello,
anyone can help me with the following issue.
I would like to have a flow to be delay until a specific column ("end time") is updated on my sharepoint list. The issue is that this specific column is updated by a Patch function in Power Apps.
So what happened is that the flow ends before that column is updated.
Below a screenshot of that specific part of the flow:
is there a way to tell the flow to delay the sending of the email until that specific column is filled?
thanks for the help
You don't want the workflow to start unless the EndTime field is populated, correct? For trigger conditions, all of them need to evaluate to true for the flow to start. So, you can use this expression to check to make sure the field is not empty: @not(empty(triggerOutputs()?['body/EndTime']))
Anyone?
Please guys,
anyone that can help me ?
Um this does not solve my issue.
Indeed, due to the Patch function in my Power Apps that specific column (date and time type) will be updated in the near future (not predictable). So I will need a formula ( if you guys know please type it) to tell the trigger to delay the start of the flow until that specific column is filled.
I tried with the function @contains(triggerBody()?['EndTime'],true), but its not working.
or with the formula not(equals(formatDateTime(triggerBody()?['EndTime'],'dd.mm.yyyy hh:mm'), null)) I inserted the formatedatetime formula cause the flow was giving me the following error:
Unable to process template language expressions in action 'Delay_until' inputs at line '0' and column '0': 'The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.'.
any leads?
I would use two workflows to do what you need. The first workflow will handle everything up until the point where you are waiting for your field to be filled in. Your second flow will run only when an item is modified and will have a trigger condition to check that the "specific column" has been filled. You can learn how to create this trigger condition from this post: Solved: Trigger Condition when specific fields are not emp... - Power Platform Community (microsoft.com)
So that the flow does not get retriggered if the item is updated after you have already sent the e-mail, you will want to add a yes/no field to your list with the default value of no. You will add this field as a trigger condition as well where the value is false. This post will show you how to set one up for yes/no fields: Power Automate Trigger Conditions made EASY - Power Platform Community (microsoft.com)
Then when the flow is triggered, be sure to update the yes/no field to true, and perform any other steps that come after the sending of the e-mail.