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%3CLINGO-SUB%20id%3D%22lingo-sub-2354195%22%20slang%3D%22en-US%22%3ERe%3A%20change%20the%20value%20of%20a%20column%20depending%20on%20the%20expiration%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354195%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053045%22%20target%3D%22_blank%22%3E%40JoseJulian%3C%2FA%3E%26nbsp%3Byou%20won't%20be%20able%20to%20do%20this%20within%20SharePoint%20on%20its%20own%20but%20will%20need%20a%20simple%20flow%20in%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20trigger%20will%20be%20the%20SharePoint%20%3CSTRONG%3Ewhen%20an%20item%20is%20created%3C%2FSTRONG%3E%20trigger.%20Next%20add%20a%20%3CSTRONG%3Edelay%3C%2FSTRONG%3E%20action%20and%20set%20it%20to%2045%20minutes.%20That%20will%20pause%20the%20flow%20for%2045%20minutes%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Flow.png%22%20style%3D%22width%3A%20647px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280719i736C943450F8F812%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-Flow.png%22%20alt%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3BNext%2C%20add%20a%20%3CSTRONG%3Econdition%3C%2FSTRONG%3E%20to%20check%20if%20the%20Status%20value%20is%20equal%20to%20approved%20-%20my%20column%20is%20a%20choice%20column%20which%20is%20why%20you%20select%20Status%20%3CEM%3EValue%3C%2FEM%3E%20from%20the%20dynamic%20content.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20leave%20the%20green%20%22if%20yes%22%20channel%20empty%2C%20but%20in%20the%20red%20%22if%20no%22%20channel%20add%20a%20SharePoint%20update%20item%20action%20and%20select%20Expired%20from%20the%20dropdown%20on%20the%20field.%20If%20your%20column%20is%20a%20text%20column%20then%20just%20type%20Expired%20into%20the%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Flow.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280720i50533D52360F5132%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-Flow.png%22%20alt%3D%222-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%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