Forum Discussion
zstjmb
Oct 29, 2018Brass Contributor
MS Forms data stored in SharePoint List
It would be really great if the questions / data collected could be promoted into a SharePoint List (like it used to be with InfoPath) because it is much easier to use than PowerApps. Users find it ...
pyvonner
Jan 18, 2020Copper Contributor
But does it transfer a multiple choice option from the form to SharePoint?
RobElliott
Jan 19, 2020Silver Contributor
pyvonner yes, the answers to a multiple choice question in the form will end up in SharePoint like this:
If you want to remove the brackets and the quotation marks this could be done in Power Automate before it creates the item in the SharePoint list.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- jlatinaJul 08, 2020Copper Contributor
RobElliott how does one remove the brackets and the quotation marks in Power Automate? I have matched the choice options in the MS Form with the choice options in the SP list. I want to make sure that I can filter and sort by the same choice options whether the entry came from the MS Form or was entered directly in the sharepoint list.