web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Getting SharePoint Fol...

Power Automate

Suggested Answer

Getting SharePoint Folder color

(0) Share

Report

Report

Posted on by JD-23121845-0

I found an article that shows how to change the color of a SharePoint folder in a flow.

However, I want to query the color of a folder.

I created a library and created folders in it and assigned each a color.

I created a flow with the action "Get files (properties only)" to get all of the files and folders in that library.

One of the outputs of "Get files (properties only)" is "Color Tag", but it's always null.

I tried adding "Get folder metadata" action, but Color is not one of the outputs.

Any idea on how to get the color assigned to each folder?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @JD-23121845-0,

Try the below HTTP request. That should return the folder names and the colorhex code.

_api/web/lists/getbytitle('@{variables('LibraryName')}')/rootFolder/Folders?$expand=Properties&$select=Name,Properties/vti_x005f_colorhex

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No

Join the conversation