Separating SharePoint List Multiple Selection Choices into Separate Rows

Question

Is there a way to split multiple selected choices into single rows in a SharePoint List? I want the user to enter all the data in one go to save time, but for data analysis purposes, I need them to be separated. Is there a method to accomplish this task? Please provide any guidance you may have. Thank you.

Answer 1

Hi @Kevin William Joseph ,

Try using below JSON code on your choice field:

Replace "display": "flex" with "display": "block"

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Kevin William Joseph ,

You want to split an item with a multi-choice column into multiple single-choice items.

I found a similar thread for you, please check it out:https://powerusers.microsoft.com/t5/Building-Flows/Split-two-multi-select-fields-in-sharepoint-list-that-are-multi/td-p/1316701

Per my knowledge, you can achieve this function through Power Automate.

In fact we are currently providing help on SharePoint in the Q&A forum, and Power Automate is a product independent of SharePoint which we are not so familiar with. Regarding the difference between these two methods which is more related to Flow, we would recommend that you go to the forum dedicated to flow for more professional help, there will be very professional people to solve the problem for you quickly

Microsoft Power Automate Community - Power Platform Community

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.