cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Flow for auto change column value in Sharepoint

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Flow for auto change column value in Sharepoint

Hi @Blader1989,

 

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!

 

View solution in original post

5 REPLIES 5
Highlighted
Resident Rockstar
Resident Rockstar

Re: Flow for auto change column value in Sharepoint

@Blader1989 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.

 

 

 

 

 

 

Highlighted
Helper I
Helper I

Re: Flow for auto change column value in Sharepoint

@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

Highlighted
Resident Rockstar
Resident Rockstar

Re: Flow for auto change column value in Sharepoint

Hi @Blader1989,

 

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!

 

View solution in original post

Highlighted
Helper I
Helper I

Re: Flow for auto change column value in Sharepoint

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

Highlighted
Resident Rockstar
Resident Rockstar

Re: Flow for auto change column value in Sharepoint

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,189)