Dear all,
Good day to you.
In my company, there is a policy for retention in Sharepoint that the files are not modified within 3 years will totally remove but our Finance team need to save these files longer than 3 years for audit so I come with them with a trick in Sharepoint that I add a new column Yes/No for their site and whenever they modify this column into Yes (default is No) then the modified date of files will be updated latest time. Example is below for your reference
Therefore, I write this new thread to seek for help to build a flow that will automatically change the value column from No to Yes. I wonder if we can build a flow for this? Any helps will be appreciated.
Thank you so much.
Solved! Go to Solution.
Hi @Blader1989,
This is my solution 🙂
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
@Blader1989 I understand correctly you want to update the Yes, No Column in Microsoft Power Automate.
If yes, you can use the Update File Properties action:
I hope this helps.
@CFernandes thank you for your reply. I tried to build the flow based on your idea but error comes from the condition as image below so could you guide me more?
Hi @Blader1989,
This is my solution 🙂
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.