Hi, Trying to build out a flow that can update a column value for a folder in a document library and wondering what 1st step would be? Would

Update a column in SharePoint document library

@Tango Not sure how you plan to trigger this flow—however in the time being you can use a Manual Trigger.

Get Folders

Fun fact. The Get Files (properties only) returns folders as well. You need to use a Filter Query to return Files only. Refer to this YT Short . To return folders only, use this filter query. You can also specify additional conditions in your Filter Query depending on your needs. Eg. You may only want to return folders where certain columns are empty. Adjust the filter query to suit your requirements.

FSObjType eq 1

Depending on how many folders you have in your SP Doc Library, I would recommend limiting the Top Count to a smaller number than the total number of items in your Doc Library. This will increase the speed of your flow runs. Instead of returning all items in your Doc Library—it'll limit the Get files (properties only) action to the number entered into the Top Count field. This can be helpful when you are building and testing your flow. Once your flow is ready to go you can remove the top count.

Loop through Folders + Update Properties

Add an Apply to Each action and loop through each item returned. Use the Update file properties action to update the column metadata for each folder returned.

You might be interested in these YT Tutorials:

3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a

Power Automate flow:

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

IN THIS VIDEO:

✅ How to avoid the Apply to Each action with a single item array

✅ How to use the item() function to access dynamic content in an array

✅ How to prevent unnecessary nested Apply to Each action loops

✅ How to use the Select action

✅ How to convert an array to a string with the Select action

✅How to use the Filter Query field

✅ How to count the number of items in an array

✅ How to use a condition control

✅ How to use the concurrency control

✅ How to set a top count

✅ How to use Compose actions for troubleshooting

----

5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Quick Links

Leaderboard > Power Automate