Powerautomate to change column value in Sharepoint List

Like (0) Share

Report

Posted on 6 Nov 2023 08:14:50 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!

All responses (2)

Answers (1)

NigusInPajamas 29 on 08 Nov 2023 at 06:55:58

Like (0)

Report

Re: Powerautomate to change column value in Sharepoint List

Thank you! It works like magic!!!
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on 06 Nov 2023 at 12:47:15

Like (0)

Report

Re: Powerautomate to change column value in Sharepoint List

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