Skip to main content
Community site session details

Community site session details

Session Id : YwuoKzxmzNWD/ZUDLGytzu
Power Automate - Building Flows
Answered

MS Forms Yes/No choice value to SharePoint list

Like (0) ShareShare
ReportReport
Posted on 12 Nov 2021 15:44:00 by 1,597 Super User 2024 Season 1

Hello,

 

I have built a flow that takes the values from MS Forms and puts them into a SharePoint list.

 

Whilst I've mapped across all the fields to columns, I am encountering this error:

 

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/S1Q3' is required to be of type 'Boolean'. The runtime value '"No"' to be converted doesn't have the expected format 'Boolean'.

 

My flow steps:

 

sudosaurus_0-1636731524470.png


The JSON is just getting the displayName, jobTitle, directorate and employeeId values from the user profile and formatting these for SharePoint list. 

sudosaurus_1-1636731644764.png

 

It's on the S1Q1 Value that it is falling over on. Whilst Yes or No is selected, this is not going to the SharePoint list even though I have a column with the same choice values.

sudosaurus_2-1636731730902.png

Any ideas?

 

Thanks.

  • mk21 Profile Picture
    4 on 23 Feb 2024 at 16:07:50
    Re: MS Forms Yes/No choice value to SharePoint list

    @sudosaurus I'm good thanks

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on 23 Feb 2024 at 15:54:15
    Re: MS Forms Yes/No choice value to SharePoint list

    @mk21 do you still need assistance?

  • mk21 Profile Picture
    4 on 25 Jan 2024 at 15:18:49
    Re: MS Forms Yes/No choice value to SharePoint list

    How can I get?

    body/GUID from form question

     

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on 12 Nov 2021 at 16:28:52
    Re: MS Forms Yes/No choice value to SharePoint list

    @Pstork1 nevermind - column formatting! ignore me 😕

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on 12 Nov 2021 at 16:23:10
    Re: MS Forms Yes/No choice value to SharePoint list

    @Pstork1 I've changed it back to a Yes/No column as that seems to work better. 

     

    I noticed on the columns where "Yes" is chosen, this shows a check in the list however on the "No" value, nothing is shown. I was expecting to see a No value with an X mark.

  • Pstork1 Profile Picture
    67,129 Most Valuable Professional on 12 Nov 2021 at 16:11:45
    Re: MS Forms Yes/No choice value to SharePoint list

    I thought it was a Yes/No column in SharePoint, not a Choice column.  Use the same code but change the true to 'Yes' and the false to 'No'

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on 12 Nov 2021 at 16:07:29
    Re: MS Forms Yes/No choice value to SharePoint list

    Hi @Pstork1 

     

    The data is now coming through but with True/False values rather than yes:

     

    sudosaurus_0-1636733226297.png

     

  • Pstork1 Profile Picture
    67,129 Most Valuable Professional on 12 Nov 2021 at 15:55:15
    Re: MS Forms Yes/No choice value to SharePoint list

    Replace the dynamic content you are using in the create Item action.  That will provide the SharePoint list with the right data type.  When displayed inside SharePoint it will show as a Yes/No value.  But it is stored as a boolean true/false.  You don't need to change the list, just change the way you are submitting the value.

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on 12 Nov 2021 at 15:52:48
    Re: MS Forms Yes/No choice value to SharePoint list

    @Pstork1 will the SP list column need to have its values changed from yes to true and no to false likewise or will they just update as is?

  • Verified answer
    Pstork1 Profile Picture
    67,129 Most Valuable Professional on 12 Nov 2021 at 15:50:27
    Re: MS Forms Yes/No choice value to SharePoint list

    Use an IF() statement to cast the "Yes" value from the form to true otherwise false.  Like this

    if(equals(outputs('Get_response_details')?['body/GUID from form question'],'Yes'),true,false)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading started
Loading complete