likert statement become sharepoint list column

[yustinus79]

hi all, i have this likert questions in forms and would like to collect all the likert statement into column in sharepoint list. 

below my form capture and the list column i want to achieve.

so if submitter select yes on all the statement, i would expect those statements are grouped in ItemsReturnedYes.

thanks for the help..

likert questionssharepoint list

[v-LilyW-msft]

Hi @yustinus79 ,

According to your description you want to collect all the likert statement into column in sharepoint list based on the results of likert questions.

I created the flow according to your description, If any misunderstanding, please kindly let me know.

Please take a try with the following steps:

This is my flow:

Flow in detail:

When a new response is submitted as below

A new item will be created as below:

Hope the content above may help you.

Best Regards

Lily

[yustinus79]

thanks a lot for your reply. so let say i have 10 likert questions then i have to make 10 switch as well?

[v-LilyW-msft · Accepted solution]

Hi @yustinus79 

Sorry for that, there is no better way, thank you！

Best regards

Lily