Nov 28 2020 09:21 AM
Nov 30 2020 01:46 AM
@Cwillia43 Hello,
Please create a new date field to contain the date for when the status was changed to ready.
Create a automation flow with Power Automate that looks at a specific listitem and gets triggered if the status is ready. Then apply the date on the new field.
Yours sincerely,
Aref Halmstrand
Nov 30 2020 05:04 AM
@Cwillia43 there is a Laura Rogers blog post that explains how to do what @ArefHalmstrand describes at https://wonderlaura.com/2020/08/25/flow-when-a-sharepoint-column-is-updated/comment-page-1/ but make sure you don't just copy her sub expression in point 4 as the apostrophes will be copied over incorrectly; put your own apostrophes in from the keyboard.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Nov 23 2021 02:40 PM
For anyone who cannot make out what the script is in the bonus section of that article:
@equals(triggerOutputs()?['body/Status/Value'], 'Completed')