Update task details fails due to boolean item

[Atonkin89]

My flow is getting data from Excel to create a Planner task, and the value for a column called 'Check 1' is an integer 1 or 0.  I want to use this value to set a checklist item as checked (if value is 1) or unchecked (if value is 0). I can't figure out how to get the dynamic content in the Checked Item field as Boolean from the 'Check 1' value. I've tried Bool function, expressions, variables, Compose, always getting errors.  Any help would be much appreciated! Thank you

[fchopo]

You could use an expression like this:

if(equals(outputs('apply_to_each')?['Check_1'],1),true,false)

Hope it helps!

Ferran

[Atonkin89]

Thank you for this.   I tried using an Expression before in the 'Checklist is Checked' field for Update Task Details, got an error, not sure if it was my syntax or something else.  Just checking...for the expression you provided, can I use it in the field called Checklist is Checked?

 

[v-chenzhi]

Hi @Atonkin89 ,

Is your problem solved?

If not, please try to write the expression with custom value.

If it helps you, please mark @fchopo 's post.

Best Regards,

Zhi Chen

[Atonkin89]

Pls clarify, what's the full syntax of that expression? It got truncated in the screenshot.  Thx