Hi!,
I'm new in building flows for SharePoint List 🙂
Just wanted to ask if it is possible to update item when Content Approval Status is changed?
for example:
Approval Status = Pending
Date = (blank)
Then if approval is changed like this:
Approval Status = Approved
Date = Today's date
Thank you in Advance! 🙂
Hi , @geenee
According to your description, you want to update the Date column when the [Approval Status] column changed to the "Approved":
This is my flow:
(1)The trigger , you need to set the trigger condition in the setting of the trigger.
@equals( triggerOutputs()?['body/ApprovalStatus/Value'] ,'Approved')
(2)The "Get changes" action:
sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
For this , you can refer to :
Power Automate: Start a Flow from a column change – Ben Prins
(3)The condition and the update item action:
formatDateTime(utcNow(),'yyyy-MM-dd')
And you need to replace your internal columnname in your side.
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang
WarrenBelz
146,601
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,942
Most Valuable Professional