cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jmatherAIPM
Level: Powered On

Flow to Smartsheet - At risk wants a bool but flow sends a string

Hello!

 

We're trying to send the bool value of True to a checkbox column within Smartsheet called At Risk.  According to the Smartsheet API doc, https://smartsheet-platform.github.io/api-docs/#cell-reference, the checkbox cell type should accept either a boolean or a string:

 

CHECKBOXBoolean: true if the checkbox is checked, false if unchecked, no value if the cell hasn't been touched yet.
string: a free-form text value.

 

We're sending the following:

 

{
  "At Risk": "true",
  "Task Name": "test email",
  "Status": "Not Started",
  "Assigned To": "jmather@healthylife.com",
  "Start Date": "2019-04-03T18:26:50Z",
  "% Complete": "0%"
}

 

And it returns the following error:

 

{
"errorCode": 1042,
"message": "The value for cell in column 6111850942228356, true, did not conform to the strict requirements for type CHECKBOX.",
"refId": "zxpu9w39e20d",
"detail": {
"index": 0
}
}
We've tried many different things to get this to work, but the boolean true message we send always gets converted into a string (which should work anyway according to the documentations for Smartsheet linked above).  We've tried different capitolizations, 1/0 instead of true/false, and using an expression to convert the string to a bool but none of them work.

 

Anyone have any ideas?

 

Thank you!

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-zhos-msft
Level 10

Re: Flow to Smartsheet - At risk wants a bool but flow sends a string

Hi @jmatherAIPM ,

I have made some tests on my side, it has the same issue with you.

From the API document, it says we can set the checkbox value to 'true' or 'false'.

I was also confused about that.

I have made a test to return the checkbox value, it was shown as  value to 'true' or 'false'.

Capture5.PNG

Perhaps the checkbox value can't be set via flow, you can only click it in the Smartsheet.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

jmatherAIPM
Level: Powered On

Re: Flow to Smartsheet - At risk wants a bool but flow sends a string

@v-zhos-msft Thank you very much for checking it out Smiley Happy

 

Workaround:  We ended up using a dropdown/picklist column instead of a checkbox column and that worked great.

2 REPLIES 2
v-zhos-msft
Level 10

Re: Flow to Smartsheet - At risk wants a bool but flow sends a string

Hi @jmatherAIPM ,

I have made some tests on my side, it has the same issue with you.

From the API document, it says we can set the checkbox value to 'true' or 'false'.

I was also confused about that.

I have made a test to return the checkbox value, it was shown as  value to 'true' or 'false'.

Capture5.PNG

Perhaps the checkbox value can't be set via flow, you can only click it in the Smartsheet.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

jmatherAIPM
Level: Powered On

Re: Flow to Smartsheet - At risk wants a bool but flow sends a string

@v-zhos-msft Thank you very much for checking it out Smiley Happy

 

Workaround:  We ended up using a dropdown/picklist column instead of a checkbox column and that worked great.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 170 members 4,605 guests
Please welcome our newest community members: