SOLVED

change the value of a column depending on the expiration time

%3CLINGO-SUB%20id%3D%22lingo-sub-2351697%22%20slang%3D%22es-ES%22%3Echange%20the%20value%20of%20a%20column%20depending%20on%20the%20expiration%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2351697%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20a%20list%20in%20sharepoint%20online%20with%20a%20status%20column%2C%20the%20status%20should%20change%20to%20%22expired%22%20if%20after%2045%20minutes%20of%20being%20%22created%22%20it%20has%20not%20changed%20status%20to%20%22approved%22.%20Is%20there%20a%20way%20to%20change%20the%20state%20using%20custom%20fields%3F%20I%20appreciate%20your%20kind%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2351697%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3ECustom%20Field%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have a list in sharepoint online with a status column, the status should change to "expired" if after 45 minutes of being "created" it has not changed status to "approved". Is there a way to change the state using custom fields? I appreciate your kind help.

2 Replies
best response confirmed by JoseJulian (New Contributor)
Solution

@JoseJulian you won't be able to do this within SharePoint on its own but will need a simple flow in Power Automate.

 

The trigger will be the SharePoint when an item is created trigger. Next add a delay action and set it to 45 minutes. That will pause the flow for 45 minutes:
1-Flow.png

 Next, add a condition to check if the Status value is equal to approved - my column is a choice column which is why you select Status Value from the dynamic content.

 

You can leave the green "if yes" channel empty, but in the red "if no" channel add a SharePoint update item action and select Expired from the dropdown on the field. If your column is a text column then just type Expired into the field.

 

2-Flow.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Dear @RobElliott

Excelent, Thank you very much! It has been a great help.

 

Best Regards,

Julian