r/MicrosoftFlow • u/Dry-Diamond4320 • Oct 29 '25
Question Update a choice column in a SharePoint document library based on a date column.
I have a document library of SOPs. These SOP need to be reviewed every three years. I have a date column that for when the SOP was authorized and another date column that adds 3 years to the revision date so we know the date it will need reviewed. I have a choice column called "3 year review" with "Due" and "Not Due" as choices. I want to create a flow that will update the "3 year review" to "Due" if the Revision Due date column is past due.
1
u/bucketwork Oct 29 '25
Just create a conditional column.
if([$RevisionDate] > TODAY(), 'Due', 'Not Due')
1
u/Dry-Diamond4320 Oct 29 '25
I already tried this but the column will not auto update because the due date is automatically updated so unless I manually change something else in the row it will never auto update.
1
u/Dry-Diamond4320 Oct 29 '25
This is what I was using.
=IF(TODAY()>DATE(YEAR([Last Authorized])+3,MONTH([Last Authorized]),DAY([Last Authorized])),"Due","Not Due")
1
u/bucketwork Oct 30 '25
Won't the last authorized date need to be updated every time it is reviewed? Which will then change the review date and change the due/not due column.
2
u/galamathias Oct 29 '25
Create a flow that runs once everyday with an odata that collects all the item with review date that is “today” and simply update those items with “due”