SharePoint Doc Library column not updating

(0) Share

Report

Posted on by ShanePhillips

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.

All responses (2)

Answers (0)

ShanePhillips 70 on at

Like (0)

Report

SharePoint Doc Library column not updating

Hi Nandit, I agree with you, it should work. I opened my desktop version of Power Automate and I saw that the SharePoint connectors were greyed out and I needed a premium license to access them. I got the free trial, and now am good to use them.

I went back to the web version thinking that maybe my user didn't have the license to do the action and I'm getting the same results. I'm trying to recreate the flow in the desktop version, but it is not as intuitive. I'm getting this error of my collection made from my Get action not being a list, datatable, or datarow. Do I need to set an output variable somehow that accomplishes this?
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report

SharePoint Doc Library column not updating

Hi SP-09101323-0,

I used the exact same actions with a Document Library containing 20 documents and it works just fine -

I wonder what's wrong. Can you try to save a copy of this flow and see that one works or try exporting and importing your flow in the environment?

That might work cause I don't there's any other issue with your flow.

Let me know how it goes.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!