A few years ago I wrote a flow to daily check the End Date in a SharePoint library, and update the Status column to Good or Expiring based on utcNOW(). I'm now trying to do something similar in my new workplace, and the whole Power Automate interface has changed.
My previous flow looked like this.
I have gotten this far:
I am stuck on this:
Copilot hasn't been very helpful:
My source data is a Document Set in a SharePoint Library, like this. Currently the status is a calculated column which is only accurate when the data are entered. The flow should run daily in the small hours to ensure these are updated daily.
You should be able to select the ID in the dynamic content menu. Alternatively, you can also add it as an expression
item()?['ID']
Below is an example
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.