Unanswered

How to delay flow using Sharepoint input that is updated by a patch function

(0) Share

Report

Posted on by YapaYapa

125

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

David_MA 12,908 Super User 2025 Season 2 on at

Like (1)

Report

Re: How to delay flow using Sharepoint input that is updated by a patch function

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.

Was this reply helpful? Yes No
YapaYapa 125 on at

Like (0)

Report

Re: How to delay flow using Sharepoint input that is updated by a patch function

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?

Was this reply helpful? Yes No
YapaYapa 125 on at

Like (0)

Report

Re: How to delay flow using Sharepoint input that is updated by a patch function

Please guys,
anyone that can help me ?

Was this reply helpful? Yes No
RayanRe 13 on at

Like (0)

Report

Re: How to delay flow using Sharepoint input that is updated by a patch function

Anyone?

Was this reply helpful? Yes No
David_MA 12,908 Super User 2025 Season 2 on at

Like (0)

Report

Re: How to delay flow using Sharepoint input that is updated by a patch function

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']))

Was this reply helpful? Yes No