Flow to run on all SharePoint online library files

[ShanmugaPriya_I]

Hi,

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

[efialttes]

Hi!

TRy with "Update file properties"

Hope this helps

[ScottShearer]

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

[ShanmugaPriya_I]

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

[ScottShearer]

@ShanmugaPriya_I 

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

[ShanmugaPriya_I]

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

[ScottShearer]

@ShanmugaPriya_I 

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

Thanks

[ShanmugaPriya_I]

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.

[ScottShearer]

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

[ShanmugaPriya_I]

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"

[ScottShearer]

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.

[ShanmugaPriya_I]

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