Unanswered

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

(0) Share

Report

Posted on by FB-04071312-0

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,351 Super User 2025 Season 2 on at

Like (1)

Report

Hi @FB-04071312-0

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.

Was this reply helpful? Yes No
FB-04071312-0 5 on at

Like (0)

Report

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.

Vaild To Screensh...

Was this reply helpful? Yes No
Michael E. Gernaey 53,351 Super User 2025 Season 2 on at

Like (0)

Report

Hi @FB-04071312-0

Ok thank you for the response. Let me review and write something up for you, its getting late so it may be tomorrow but I am setting your thread aside so I can write up a pseudo flow for you.

Was this reply helpful? Yes No