Formatting of MS Forms data in SharePoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-2062784%22%20slang%3D%22en-US%22%3EFormatting%20of%20MS%20Forms%20data%20in%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2062784%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Forms%2C%20SP%20List%20and%20Flow%20all%20set%20up%20%26amp%3B%20working%20correctly%20to%20pull%20Forms%20responses%20into%20a%20list%20and%20then%20dashboard%20via%20Power%20BI.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Forms%20data%20from%20radio%2Fselection%20options%20is%20appearing%20as%20per%20below%2C%20which%20looks%20bad%20in%20SP%20and%20even%20worse%20in%20PowerBI!%26nbsp%3B%20Is%20there%20any%20way%20to%20amend%20this%2C%20so%20that%20the%20%5B%22%20%22%5D%20is%20removed%20and%20text%20can%20be%20displayed%20better%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-01-14%20235709.png%22%20style%3D%22width%3A%20164px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246472iE71EB34BA5FFD0C3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-01-14%20235709.png%22%20alt%3D%22Screenshot%202021-01-14%20235709.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2062784%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2064321%22%20slang%3D%22en-US%22%3ERe%3A%20Formatting%20of%20MS%20Forms%20data%20in%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2064321%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F929873%22%20target%3D%22_blank%22%3E%40TD-19976%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20to%20manage%20this%20within%20Power%20automate%20flow%20only.%20You%20can%20extract%20the%20actual%20value%20from%20radio%20options%20in%20flow%20and%20save%20it%20in%20SharePoint%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20need%20more%20efforts%20if%20you%20have%20multiple%20selection%20type%20questions%20in%20Microsoft%20forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20below%20links%20for%20more%20information%3A%3C%2FP%3E%3COL%3E%3CLI%3E%3CA%20title%3D%22Power%20Automate%3A%20Save%20multi-choice%20Microsoft%20Forms%22%20href%3D%22https%3A%2F%2Fmanueltgomes.com%2Fmicrosoft%2Fpowerautomate%2Fmulti-select-form-sharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EPower%20Automate%3A%20Save%20multi-choice%20Microsoft%20Forms%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%3CLI%3E%3CA%20title%3D%22Record%20Microsoft%20Form%20choice%20response%20to%20the%20SharePoint%20list%22%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FI-Found-A-Bug%2FRecord-Microsoft-Form-choice-response-to-the-SharePoint-list%2Ftd-p%2F99846%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERecord%20Microsoft%20Form%20choice%20response%20to%20the%20SharePoint%20list%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a Forms, SP List and Flow all set up & working correctly to pull Forms responses into a list and then dashboard via Power BI.

 

But...

 

The Forms data from radio/selection options is appearing as per below, which looks bad in SP and even worse in PowerBI!  Is there any way to amend this, so that the [" "] is removed and text can be displayed better?

 

Screenshot 2021-01-14 235709.png

 

1 Reply

@TD-19976 

 

You need to manage this within Power automate flow only. You can extract the actual value from radio options in flow and save it in SharePoint list.

 

You may need more efforts if you have multiple selection type questions in Microsoft forms.

 

Check below links for more information:

  1. Power Automate: Save multi-choice Microsoft Forms 
  2. Record Microsoft Form choice response to the SharePoint list 

Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.