web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / What is the formula fo...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 83

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!

Categories:
I have the same question (0)
  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 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.

     

     

  • CU06111240-0 Profile Picture
    83 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?

  • Anil_g Profile Picture
    668 Moderator 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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard