cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShanmugaPriya_I
Regular Visitor

Flow to run on all SharePoint online library files

Hi,

 

Need to update a field for SharePoint online library files. Any idea about how to achieve it using MS Flow

11 REPLIES 11
efialttes
Super User
Super User

Hi!

TRy with "Update file properties"

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



ScottShearer
Super User
Super User

@ShanmugaPriya_I 

As suggested by @efialttes  you'll want to use an Update file properties action.  If your intent is to do a wholesale update of all files at once, you'll use a Get files - properties only action first.  Then loop through all the files and use the Update file properties action on each one.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Update file properties action is fine. But how to update all documents at a time?

@ShanmugaPriya_I 

See my example below where I update the column called MyText for all documents:

UpdateProps.jpg

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Can you please help me to assign dynamic or runtime values for library name and limit column by view field

 

@ShanmugaPriya_I 

Can you provide a bit more detail on what you need to do?

Thanks

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

I have a list(more like "My task") in which people will choose approved or rejected options. Based on their I have to update document library file with options. There are multiple libraries so which one will be decided only through runtime. Also we already crossed the lookup column limits, so I have to choose not only library name but also limit column by view option in runtime.

@ShanmugaPriya_I 

You can dynamically populate both the site and library sections of SharePoint library related actions.

For the site, you can store the site URL in a variable or compose action.  In the site dropdown, select enter a custom value and supply your variable or compose action.

You'll do the same thing for the list, but you'll need the list ID.  To obtain the list ID, go to the list settings in your browser.  At the end of the URL you'll see List = and and then a bunch of characters. Everything after List= is the list ID.

I'm not sure what you ean when you say" limit column by view option in runtime".

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

In the image u have shared earlier, go to get files action then click on advanced options. You can see a field as "limit column by view"

If you select a view in the limit columns area, only the columns in that view will be returned to Flow.  The rows returned are not filtered even if the view has a filter.  So, if you want to limit the columns available within your Flow, create a view containing only the columns you want and select that view.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Yeah that's how it will function. But we are going to give library value dynamically ,so view also to be populated during runtime. But view is not working during runtime entry

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,450)