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

%3CLINGO-SUB%20id%3D%22lingo-sub-1773906%22%20slang%3D%22en-US%22%3EUpdate%20all%20sharepoint%20elements%20depending%20on%20if%20they%20are%20folder%20or%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1773906%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20have%20a%20PowreApps%20that%20connects%20to%20a%20SharePoint%20Library%20and%20gets%20all%20the%20info%20needed.%20I%20need%20to%20add%20a%20field%20in%20the%20SharePoint%20Library%20that%20differentiates%20between%20the%20elements%20that%20are%20folder%20and%20the%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20doing%20this%20with%20a%20Power%20Automate%2C%20but%20the%20%22Apply%20to%20each%22%20only%20repeats%20100%20times%2C%20even%20if%20the%20SharePoint%20has%20about%205000%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Azaak_0-1602577712086.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226229iB151B5D4603536D7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Azaak_0-1602577712086.png%22%20alt%3D%22Azaak_0-1602577712086.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20of%20updating%20all%20the%20items%20from%20the%20SharePoint%20list%20using%20Power%20Automate%20or%20maybe%20a%20configuration%20option%20from%20SharePoint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1773906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1777484%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20all%20sharepoint%20elements%20depending%20on%20if%20they%20are%20folder%20or%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1777484%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F362975%22%20target%3D%22_blank%22%3E%40Azaak%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20add%20the%20%22Content%20Type%22%20site%20column%20to%20the%20view.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22stormin_30_0-1602627757616.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226487i09E539DE1AD6C963%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22stormin_30_0-1602627757616.png%22%20alt%3D%22stormin_30_0-1602627757616.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENorm%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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
Highlighted

Hi @Azaak,

 

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

stormin_30_0-1602627757616.png

I hope this helps.

 

Norm

 

 

Highlighted

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!