Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

What is the formula for a timestamp being used from a SharePoint column?

Posted on by 72

Can someone please guide me on how to set up this flow? I want the email to be delayed until the date entered in the app as the release date, but I am not sure how to do that. Currently, the number of days selected between 1- 5 days is how long the email is delayed until sent. The trigger for this flow is the number of days selected when an item is created. What if four days are selected and after one day of the item being on hold, they want to modify the number of days to three. This flow would be set up when an item is modified. How do I set up a delay until the release date that is modified? Any help would be greatly appreciated. Thank you in advance!

  • Anil_g Profile Picture
    Anil_g 668 on at
    Re: What is the formula for a timestamp being used from a SharePoint column?

    @tchamb2 

     

    A better approach would be to schedule it to run daily and then get the items with odata filter on release date equals todays date..you would get all items that are ready for today and you can do your further action

     

    cheers

  • CU06111240-0 Profile Picture
    CU06111240-0 72 on at
    Re: What is the formula for a timestamp being used from a SharePoint column?

    What next action should be used if the release date is modified? Is there a timestamp for a column that can be used for the delay until option?

  • ManishSolanki Profile Picture
    ManishSolanki 14,981 on at
    Re: What is the formula for a timestamp being used from a SharePoint column?

    Hi @tchamb2 

     

    The easiest way is to create a new automated flow with trigger "When an item is created or modified". This flow will trigger when any column or field is modified in an item. To check if release date has been modified use "Get changes for an item or a file" action.

     

     

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard