Hello, I'm fairly new to Power Automate, and I have a need to add a column to our SharePoint doc library that says whether or not an item is a folder. All documents get a "No" in this column automatically when uploaded. Folders do not and are left null. This is to enable a Power Apps document library experience for selecting documents trained on for a training tracker writing to a List.
I created my column in the library and verified that it works with new docs, however the library has over 11,000 documents already and to populate this column I was going to write a Flow to update kind of "backend".
In order for this to work I have to enable management of content types, and these are the column settings:
My flow:
The apply to each step is set to "body/value".
Condition is:
I've removed the URL for this snip but otherwise it's populated. Here are the settings for the update file properties action of the True side. The False side of the condition is blank as no action is needed if the library item is a folder.
The flow runs successfully however the library is not updating the "hiddenIsFolder" column to "No" for documents.
Any help to resolve where I went wrong or why it isn't executing would be appreciated. Thank you in advance.
