Convert Form response Text into a Yes/No Column in SharePoint

Like (0) Share

Report

Posted on 18 Jun 2023 08:24:40 by Angry_Sys_Admin

181

Good morning all.

I have a form which staff have to complete for certain tasks, I need this form copied into a sharepoint list which is no problem.

However, the column on the SharePoint list is a Yes/No (checkbox) column, this means I can't literally copy the response because you can't use dynamic content with this type of formatting in power automate. So, is there an expression I can use, to convert the response from the form (Yes or No) into this particular field?

I tried using update item immediately after create an item but that just wiped the whole row.

I cant change the column format because it needs to be a slider in powerapps not a dropdown.

All responses (1)

Answers (0)

RobElliott 10,166 Super User 2025 Season 2 on 18 Jun 2023 at 12:41:49

Like (2)

Report

Re: Convert Form response Text into a Yes/No Column in SharePoint

@Angry_Sys_Admin add a string variable (which in this example I've named varSatisfied) and for the value select the Forms question that had the Yes/No answer:

Then add a compose action and add the following expression:
if(equals(variables('varSatisfied'),'Yes'), true, false)

In your create item action, for the Yes/No column select the outputs of the compose action.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.