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
You could use an expression like this:
Hope it helps!
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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!