Hi
I am wanting to utilise the category colours in the Create a Task action for planner. I have tried several different if statements in an expression to try get it to work but it isn't. The field looks like it wants a true/false statement but when you click it, the options are yes/no/custom content.
I have a column in the SP list called Urgency. With values red, amber, green. Depending on this value I want automate to colour the task in a corresponding colour. So if the value is red, I want it to use the red category. I have tried the following code;
if(equals(item()?['triggerOutputs()']['body/Urgency/Value'], '0'), True, False) - in the output for the when an item is created trigger, the value under Urgency is showing 0. I assume this means red=0, amber=1 and green=2.
if(equals(item()?['triggerOutputs()']['body/Urgency/Value'], 'Red'), True, False)
if(equals(item()?['triggerOutputs()']['body/Urgency#Id'], '0'), 'Yes', 'No') - in the output for the trigger it shows Urgency section as Urgency#Id
if(equals(item()?['triggerOutputs()']['body/Urgency#Id'], 'Red'), 'Yes', 'No')
I just can't get it to work. Can anyone help please?
Screenshot
27
Share
Report
All responses (
Answers (
