Update all sharepoint elements depending on if they are folder or file

Copper Contributor

Hi

I have a PowreApps that connects to a SharePoint Library and gets all the info needed. I need to add a field in the SharePoint Library that differentiates between the elements that are folder and the files.

 

I've tried doing this with a Power Automate, but the "Apply to each" only repeats 100 times, even if the SharePoint has about 5000 items.

 

Azaak_0-1602577712086.png

 

 

Is there any way of updating all the items from the SharePoint list using Power Automate or maybe a configuration option from SharePoint?

 

I

2 Replies

Hi @Azaak,

 

You can add the "Content Type" site column to the view. 

stormin_30_0-1602627757616.png

I hope this helps.

 

Norm

 

 

Hi @stormin_30 !

 

Thanks for the help, but my issue is that the column IsFolder is not delegable for my PowerApps application, that why I tought about creating a Option Column that I could delegate correctly:

Azaak_0-1602655717246.jpeg

 

If I use the new column "FileType" (With two options, "Expedient" and "File") it works correctly:

Azaak_1-1602656173491.png

 

I'd want either to be able to delegate IsFolder or to copy that column into an option one.

 

Thanks!