I'm trying to compose an HTML table whereby two Yes/No fields in Sharepoint will be row shaded(<tr> tag) if one or both is/are Yes (true).
My compose input look like this:
could you just use column formatting (JSON) for this in the modern sharepoint view? I think that'd be a lot easier. If you're using classic sharpoint doing the same via JS link on a list view would also be simple. Perhaps you have a good reason to do this in flow?
If you wish to go the html table route in flow I'd:
If any of these solutions work, please mark this as answered.
Hi @RonDinoso ,
Is this expression valid after running Flow? Are there any errors?
If so, please provide it to us to analyze it.
Hi @v-bacao-msft ,
The Flow runs every morning, gets items that were appended or modified within a day's time, builds the HTML table to be emailed. All of the compose actions use the replace() string function to modify the various tags in the table, but only the "Style tr tag" uses an if statement against two conditions. The or() operator looks at the two Yes/No columns in my Sharepoint list. I figured if the value is a Yes in either column, then the or() operatore will return a true. If the or() function is true, then it modifies the <tr> tag by changing the background-color.
The flow works up to the if condition. I'm thinking don't have have my or() test correct. Is the Yes/No column in a Sharepoint List treated as a string value in Flow, or a boolean true/false?
Hi @RonDinoso ,
The value returned by Yes/No column is true/false, so you could try to remove the bool() function and directly reference the field value.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.