Create formatted table columns based on condition in power automate

(0) Share

Report

Posted on by NaqibDanish

Hello the forum participants and contributors,

I am almost new in Power Automate,

In a Power Automate flow, I get data from a SharePoint list, which grabs a list of reports, if the report status marked as "Yes", I show the status as green, and red otherwise, in the select action of power automate in the report status field, I created this code:"

but this code only displays this "Yes " instead of coloring it.

I would appreciate your support in this.

Categories:

General topics

I have the same question (0)

All responses (19)

Answers (2)

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!
Hi , @NaqibDanish
We can not format the column color in Power Automate . If you want to set the font color based on the value in SharePoint List , you need to format the column here :

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "inlineEditField": "[$Your Internal column Name]", "txtContent": "[$Your Internal column Name]", "style": { "color": "=if([$Your Internal column Name]=='Yes', '#00ff00', '#ff0000')" }}

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
NaqibDanish 30 on at

Like (0)

Report
Copy link

Link copied!

Thank you @yueyun zhang, one of the developer that i follow on Youtube does formatting in power automate, i posted him the error, he says that formatting can be done in Power automate: The link to his youtube video:
https://www.youtube.com/watch?v=VnWg-Eox37Q&lc=UgzY_srgg0xCaJeP8Jp4AaABAg.9zr-yIMiRQk9zr0buSSdz5

Was this reply helpful? Yes No
NaqibDanish 30 on at

Like (0)

Report
Copy link

Link copied!

@v-yueyun-msft, where to place the json code, i couldnt really find it?
Thank you

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi, @NaqibDanish
Thanks for the reply, I just came back from lunch!
What type of column do you have? I'll look at your video and get back to you.
For json can be put here:

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi, @NaqibDanish
This video use the "Create Html table" to create a html table and add the "Yes " in it . This generated html code is put in the "Send to an email v2" action's body as html code. And this is not format the font color in SharePoint List in my understand.

. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
NaqibDanish 30 on at

Like (0)

Report
Copy link

Link copied!

@v-yueyun-msft, I appreciate your response. I exactly want the same thing, the only difference is that i don't to send it to email but sending it to a team channel or group. What I did is, I fetched the sharepoint items in powerautomate, based on the reportstatus, first want to color code it, and then send it to a teams channel so that group members can easily recognize by text color which report is pending and which one completed.

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @NaqibDanish
Thanks for your quick response! Sou do you mean you use this action in the last?
If this , it can be realized to format the color using html coed, can you share how you flow set in your side?

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
NaqibDanish 30 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response, yes, exactly, please see my screenshot,

Was this reply helpful? Yes No
NaqibDanish 30 on at

Like (0)

Report
Copy link

Link copied!

This is another screenshot, where i removed the code tag from report status as it was not working:

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (1)

Report
Copy link

Link copied!

Hi , @NaqibDanish
I test it in my side , you can put the tag in the "Create html table" action.
This is my sharePoint list:
This is my flow:
item()?['ReportStatus']?['Value']
if(equals(item()?['ReportStatus'],'Yes' ) ,'green', 'red' )
item()?['ReportStatus']
replace(replace(replace(body('Create_HTML_table'),'<','<') ,''',string('''')) ,'>' , '>')

The result is as follows in teams:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No