Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Release Date + Validity = Vaild To (Date) For Quick Parts

(0) ShareShare
ReportReport
Posted on by 4
I'm trying to create a "Valid to" date to show a date of when a document has to be reviewed agian. Like a timer. I have a release date made in Power Automate which takes the date of "Publish" and puts it in. I want to use that column with a choice column "Validity" (2 options, 12 months or 24 months). I cant just do a calculated column since it wont show in Quick Parts. So i've been trying to use Power Automate but I'm lost. I cant figure out the correct condition, I've tried to use when Validity and Release date is NOT empty, run flow. But it wont work and when it does, it wont show if i have chosen 24 months. 
  • FB-04071312-0 Profile Picture
    4 on at
    Release Date + Validity = Vaild To (Date) For Quick Parts
    Hi @Michael E. Gernaey I'm working with SharePoint and Power Automate and need help with setting a "Valid to" date for documents. 

    I'll try to explain in steps, as suggested: 

    1. What I'm using: 
    Platform: Sharepoint
    Trigger: I'm using Power Automate to trigger when a document is created or modified:

    Fields in SharePoint: 

    Release Date: Date cloumn. It gets filled in automatically by Power Automate when the version of the document end in ".0" (indicating it's published).
    Validity: A choice column with two options - 12 months and 24 months. 
    Valid To: Date column where i want the calculated date to go. 

    2. What i want to achive: 
    When the Release Date and Validity fields are filled: 
    If Validity is 12 months, then set Vaild to = Release Date + 12 months 
    If Vailidity is 24 months, then set Valid to = Release Date + 24 months

    This Vaild To date should be used in Quick Parts later, so it must be a regular column/field in SharePoint, not a "Calculated column" (A choice of column inside SharePoint) 

    3. What I've tried: 
    I made a Power Automate Flow. 
    The trigger is "When a file is created or modified (properties only)"
    I tried adding a condition like this: 

    @and(
      not(empty(triggerOutputs()?['body/ReleaseDate'])),
      not(empty(triggerOutputs()?['body/Validity']))
    )


    But the flow doesn't always work, Sometimes it doesn't run or it runs but doesn't update the Valid To correctly when 24 months is selected. 

    4. What i need help with: 
    The corret way to structure my flow so it only runs when both Release Date and Vailidty are filled
    How to update the Vaild To field correctly depending on the chosen Validity (12 or 24 months)
    Bonus: How to avoid loops or only make this run once when either Release date or Validity is updated.

    Let me know if i can share some screenshots, I've uploaded what my columns look like for a better understanding. 
  • Michael E. Gernaey Profile Picture
    44,275 Super User 2025 Season 1 on at
    Release Date + Validity = Vaild To (Date) For Quick Parts
     
    I am super sorry but I am not following. I mean I sort of get what you are saying, but the details are... a bit confusing. Let me try to break it down and hopefully I can help.
     
    Firstly, what is your Datasource, you do not mention, so when speaking of options, its different in Dataverse versus SharePoint versus other platforms.
     
    I'm trying to create a "Valid to" date to show a date of when a document has to be reviewed agian. Like a timer.
    --Logistically this makes sense, you want a column that can be checked (potentially) but a scheduled flow, on a daily basis to see if this date is hit, or within the range you want to check on. I think 
     
    I have a release date made in Power Automate which takes the date of "Publish" and puts it in.
    --Takes the date from where?
    --Puts it in where (it doesn't say)
     
    I want to use that column with a choice column "Validity" (2 options, 12 months or 24 months).
    --What column again you didn't say, what data type is it?
    --What does I want to use that "Column" with the choice mean? Are you saying based on some business logic combined with the New Column value, you want to set the choice to either 12 months or 24 months? 
     
    I cant just do a calculated column since it wont show in Quick Parts.
    --not sure what this means
     
    So i've been trying to use Power Automate but I'm lost.
    I cant figure out the correct condition, I've tried to use when Validity and Release date is NOT empty, run flow.
    But it wont work and when it does, it wont show if i have chosen 24 months. 
     
    --Please share your flow, with all steps open and all your inputs etc showing.
    ----As for the line I made bigger, I do not understand. You say condition, but then you speak of a Trigger.
    ----Are you saying that when someone creates a new record (in whatever storage you are talking about), and if those dates are empty, you want the flow to run?
    ----But then you go back to a condition statement
     
    Apologies but its really not clear what you need but I did my best to make an educated guess, but you have to share in better details (think of it in steps not a paragraph), of what you want
     
    1. Person creates a record in SharePoint using a Form
    2. I want my flow to trigger
    3. I want the flow to check bla bla
    then do bla bla
     
    Like that.
     
    Also share what you have so if its close we can help you fix it.
     
     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1