cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yustinus79
Helper II
Helper II

likert statement become sharepoint list column

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 questionslikert questionssharepoint listsharepoint list

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @yustinus79 

 

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

 

Best regards

Lily

View solution in original post

3 REPLIES 3
v-LilyW-msft
Community Support
Community Support

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:

v-LilyW-msft_0-1620957817727.png

 

Flow in detail:

v-LilyW-msft_1-1620957817733.png

v-LilyW-msft_2-1620957817750.png

v-LilyW-msft_3-1620957817751.png

v-LilyW-msft_4-1620957817760.png

v-LilyW-msft_5-1620957817769.png

 

When a new response is submitted as below

v-LilyW-msft_6-1620957817771.png

A new item will be created as below:

v-LilyW-msft_7-1620957817772.png

Hope the content above may help you.

 

Best Regards

Lily

yustinus79
Helper II
Helper II

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

Hi @yustinus79 

 

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

 

Best regards

Lily

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,397)