web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow for auto change c...
Power Automate
Answered

Flow for auto change column value in Sharepoint

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

1.JPG2.JPG

 

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.

 

Categories:
  • CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    @Anonymous I understand correctly you want to update the Yes, No Column in Microsoft Power Automate.

     

    • So you want to loop through all the documents in a library\Folder.
    • Update the column\ such that the modified date also get updated?

     

    If yes, you can use the Update File Properties action:

     

    CFernandes_1-1598346858809.png

     

    I hope this helps.

     

     

     

     

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @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? 

    Capture.JPGCapture2.JPG

  • Verified answer
    CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    Hi @Anonymous,

     

    This is my solution 🙂

    CFernandes_0-1598350819214.png

     

    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!

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @CFernandes  you are my savior 😁 thank you so much. You made my day ^^

  • CFernandes Profile Picture
    8,504 Most Valuable Professional on at

    @Anonymous Thank you 😊 Those are some of the kindest and meaningful words.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 423

#2
11manish Profile Picture

11manish 308 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 177

Last 30 days Overall leaderboard