Answered

Power automate flow to check folder color

(2) Share

Report

Posted on by geostylianou

Hi, i am currently using a flow in order to create planner task whenever a file is added to the Documents library.

i am checking if the file is folder and then o procced creating the planner item.

i am trying to add one more roe to my condition in order to check folder color and i will also set priorities to the planner task depending on folder's color.

i am able to identify throu rest api that if for exampe a folder is blue ther is an expanded property of "

<d:vti_x005f_colorhex>5</d:vti_x005f_colorhex>

i have also confirm it through powershell that this is the correct attribute as you can see on the screenshot but i am not able to extract that info using power automate

Any ideas?

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @geostylianou

I don't think color of folder is found as property of any sharepoint API response, based on information which i have received.

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
geostylianou on at

Like
a
(2)

Report
Copy link

Link copied!

hi, thank you for your answer but considering i can create folder and give it custom (see attachment) color using http request from power automate, i believe i can also get that property

Was this reply helpful? Yes No
geostylianou on at

Like
a
(0)

Report
Copy link

Link copied!

Hi all,

is it possible to set a variable using the http response body?
i am able to see the required attribute on the http response body.

Was this reply helpful? Yes No
geostylianou on at

Like
a
(1)

Report
Copy link

Link copied!

*Update*
found the solution thnx all.

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @geostylianou

Could you share how to do that

If you can share that would be great as I was also researching on this but did not get any leads for this

Also this would help if any one comes for looking same query in future

Just share solution and mark it as solution which helps !

Was this reply helpful? Yes No
geostylianou on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, @Nived_Nambiar ,

first you need to get expanded item properties using the http request as follows:
next you initialize a variable fetching data from the http response.
my response was this:
so i used the following dynamic content to set the variable

Was this reply helpful? Yes No
geostylianou on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Nived_Nambiar ,
it seems that my variable is not correct.
do you know how can select the string i want after i parse the json response from http to my condition?

Was this reply helpful? Yes No
Verified answer

geostylianou on at

Like
a
(2)

Report
Copy link

Link copied!

*new update*
Using compose action i managed to parse the required property to a new variable.
I am elaborating:
using compose action with the following query to navigate to the required property inside the json

then use the action initialize a variable and pass the output from the compose action
to make sure the variable has the correct value i sent an email passing the variable to the mail body

and this is the mail i received after creating a blue folder

color/code panel

Was this reply helpful? Yes No
LE-15101539-0 2 on at

Like
a
(1)

Report
Copy link

Link copied!

geostylianou - I am not able to see most of the images on these posts. I am encountering this issue now - I would like to be able to see the color of folders in SharePoint using Power Automate. Any chance you could get me the screen shots? Thanks!

Was this reply helpful? Yes No
CU23021713-0 3 on at

Like
a
(0)

Report
Copy link

Link copied!

any update on the screenshots?

Was this reply helpful? Yes No