Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

MS Forms Yes/No choice value to SharePoint list

(0) ShareShare
ReportReport
Posted on 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 at
    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 at
    Re: MS Forms Yes/No choice value to SharePoint list

    @mk21 do you still need assistance?

  • mk21 Profile Picture
    4 on at
    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 at
    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 at
    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
    66,836 Most Valuable Professional on at
    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 at
    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
    66,836 Most Valuable Professional on at
    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 at
    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
    66,836 Most Valuable Professional on at
    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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492