Skip to main content

Notifications

Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by 121

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:

Fedegallo_0-1683042024245.png


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

  • David_MA Profile Picture
    David_MA 9,039 on at
    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']))

  • RayanRe Profile Picture
    RayanRe 13 on at
    Re: How to delay flow using Sharepoint input that is updated by a patch function

    Anyone?

  • YapaYapa Profile Picture
    YapaYapa 121 on at
    Re: How to delay flow using Sharepoint input that is updated by a patch function

    Please guys,
    anyone that can help me ?

  • YapaYapa Profile Picture
    YapaYapa 121 on at
    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.'.

     

    Fedegallo_0-1683120149067.png

     


    any leads?

  • Verified answer
    David_MA Profile Picture
    David_MA 9,039 on at
    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.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard