Using Flow to Create Item with Yes/No Column from Microsoft Forms

[prism667]

Hi, 

I have created a microsoft form that has multiple choice and yes/no questions. I have figured out how to get the multiple choice answers to display on the sharepoint item that is created, however, I cannot figure out how to do it for the Yes/No column. 

The column in the screenshot is "Secondary Contact?"

Any help would be greatly appreciated. 

[alaabitar]

Hello,

You can just put in the expression tab true or false like that

Best regards,

Alaa

[prism667]

Hi, 

Thank you for responding! Will this solution account for whether the form responder answers yes or no to the question? because I want their answer to be correctly reported in the sharepoint list. 

[alaabitar]

Yes definitivly you can check what the responder answered and then update the sharepoint list with true or false accordingly

[prism667]

Hi, 

So my issue is that I want the flow to automatically pull the responder's response from the form and update the specific column with yes or no based on their answer. I do not want to manually update the sharepoint item, if possible. Currently, every column is doing that except for the yes or no column. 

[alaabitar]

Yes you can definitively update automatically in the field of the sharepoint list that you want to update can you use and expression with an if statement that looks like that

if(outputs('Get_response_details')?['body/r3b3d3574f01445d08267ac38ba79b8a2'],'yes',true)

with outputs('Get_response_details')?['body/r3b3d3574f01445d08267ac38ba79b8a2'] the get response item that correspond to your Yes/No question

[prism667]

I keep getting an error that the expression is not valid. Am I going into the create item action > Secondary Contact? (name of the column in question) > and then typing the expression there?

[prism667]

Sorry, I have attached the exact error it is giving me to this response. 

This is the expression I put there: 

if(outputs('Get_response_details')?['r621fe34a011f4e09bef71a009a7f238c'],'yes',true)

[alaabitar]

And what is the type of the column in your sharepoint list ?

[prism667]

It is a yes/no column

[alaabitar · Accepted solution]

Sorry my bad I had a mistake in the syntax, your if statement should look like

if(equals(outputs('Get_response_details')?['r621fe34a011f4e09bef71a009a7f238c'],'Yes'),true,false)

[prism667]

awesome! you were extremely helpful.