You’re offline. This is a read only version of the page.
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.
Share
Report{
"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?
That's great thanks @tom_riha
Hello @sudosaurus ,
you have a . (dot) before the 'Yes', it should be a comma.
All responses (
Answers (
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))HI @tom_riha
Could you inspect the below? Not sure what I'm getting wrong on this one?
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
)
)
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
