Logic Apps SharePoint Create Item BadRequest 400 String was not recognized as a valid Boolean

[sudosaurus]

Hello!

In Logic Apps my workflow is getting responses from MS Forms and populating the information into a SharePoint list.

This was working all well and find in Power Automate however since moving to Logic Apps, it appears that my Create Item action is falling over with the message status of 400 with the message: String was not recognized as a valid Boolean.

{
  "status": 400,
  "message": "String was not recognized as a valid Boolean.\r\nclientRequestId: b7e7f139-64ba-4937-873f-543ffc58942e\r\nserviceRequestId: b7e7f139-64ba-4937-873f-543ffc58942e"
}

I'm wondering if it has something to do with how the form questions/answers are being incorrectly formatted when added to the list? As when I take out this Q1 field, the item gets created successfully. So it creates the item ok with the other details just not with any questions or answers.

Any ideas?

[tom_riha]

Hello @sudosaurus ,

I'd try to convert it from Yes/No values to true/false values, e.g. with an if(...) expression.

if(
    equals(<value from Forms>,'Yes'),
    true,
    if(
        equals(<value from Forms>,'No'),
        false, 
        null
    )
)

[sudosaurus]

HI @tom_riha 

Could you inspect the below? Not sure what I'm getting wrong on this one?

if(equals(body('Get_response_details')?['r627f4b6e623d4a72b97f27808180f880'].'Yes'),true,if(equals(body('Get_response_details')?['r627f4b6e623d4a72b97f27808180f880'],'No'),false,null))

[tom_riha · Accepted solution]

Hello @sudosaurus ,

you have a . (dot) before the 'Yes', it should be a comma.

wrong:
if(equals(body('Get_response_details')?['r627f4b6e623d4a72b97f27808180f880'].'Yes'),true,if(equals(body('Get_response_details')?['r627f4b6e623d4a72b97f27808180f880'],'No'),false,null))

correct:
if(equals(body('Get_response_details')?['r627f4b6e623d4a72b97f27808180f880'],'Yes'),true,if(equals(body('Get_response_details')?['r627f4b6e623d4a72b97f27808180f880'],'No'),false,null))

[sudosaurus]

That's great thanks @tom_riha