This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXX%3C/text%3E%3C/svg%3E)
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.
Ahhh I think maybe I was not clear I would like to separate each choice into a separate item in the sharepoint list like this. For the user to input each one manually one by one would be quite time consuming.
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.