Answered

Powerautomate to change column value in Sharepoint List

(0) Share

Report

Posted on by NigusInPajamas

Hello,

I've created an entry tool in powerapp, on the screen i disable the visibility of an "Edit" button to false so in order to edit the entry that was entered they need to request for an unlock. So i create a screen for "Unlock" and also a new Sharepoint List so that if the powerautomate picks up a new entry it will send an approval to the leaders then after approved the column "Status" in Sharepoint List will display "Approved". Is it possible that powerautomate will change the value of the "Status" column in sharepoint list from "Approved" to "Locked" after 24hrs, so that they can only edit the items or the entry after 24hrs? Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @NigusInPajamas

You could add the following actions to achieve this:

1. Create a new automated cloud flow with "When an item is added or modified" trigger.

2. Set the trigger condition on status so that flow will execute only when status changes to "Approved".

2. Add delay action to pause the execution of flow to 24 hours.

3. Add update item action to update the status from Approved to Locked.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
NigusInPajamas 29 on at

Like (0)

Report
Copy link

Link copied!

Thank you! It works like magic!!!

Was this reply helpful? Yes No