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

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
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 ) )

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report

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))

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
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))

Was this reply helpful? Yes No
sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report

That's great thanks @tom_riha

Was this reply helpful? Yes No