Results from a form - multiple answers - format in SP list

%3CLINGO-SUB%20id%3D%22lingo-sub-235882%22%20slang%3D%22en-US%22%3EResults%20from%20a%20form%20-%20multiple%20answers%20-%20format%20in%20SP%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-235882%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20feeding%20my%20sp%20list%20with%20answers%20from%20a%20form%20%2C%20by%20using%20a%20flow.%20Everything%20works%20well%2C%20but%20i'm%20curious%20for%20the%20following%20issue%20%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20form%20i%20have%20several%20multiple%20choice%20questions%2C%20for%20which%20the%20user%20is%20allowed%20to%20select%20multiple%20answers.%20These%20answers%20are%20shown%20in%20my%20sp%20list%2C%20but%20it%20looks%20very%20messy.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3Efex%3A%20There%20is%20a%20question%20'%20what%20are%20your%20interests%2C%20and%20this%20is%20how%20the%20answers%20are%20shown%20in%20the%20list%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%5B%22cars%20%26amp%3B%20motors%22%2C%22computers%20%26amp%3B%20IT%2C%22games%22%2C%22art%22%5D%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIs%20there%20a%20workaround%20to%20display%20these%20answers%20in%20another%20way%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20quite%20sure%20this%20is%20fixable%20with%20the%20Json%20formatting%2C%20but%20this%20is%20not%20my%20strongest%20skill.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20need%20a%20full%20fix%2C%20just%20a%20push%20in%20the%20right%20direction%20or%20an%20idea%20how%20to%20fix%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(example%20in%20attachment%20)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJan.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-235882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236717%22%20slang%3D%22en-US%22%3ERe%3A%20Results%20from%20a%20form%20-%20multiple%20answers%20-%20format%20in%20SP%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236717%22%20slang%3D%22en-US%22%3ESeems%20very%20promising!!%20%3A)%3C%2Fimg%3E%20I%20will%20test%20this%20and%20provide%20you%20with%20feedback.%3CBR%20%2F%3E%3CBR%20%2F%3Emany%20thanks%20for%20your%20time%20%26amp%3B%20effort%20Matt!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236488%22%20slang%3D%22en-US%22%3ERe%3A%20Results%20from%20a%20form%20-%20multiple%20answers%20-%20format%20in%20SP%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236488%22%20slang%3D%22en-US%22%3E%3CP%3EDepending%20on%20what%20you%20want%20to%20do%20and%20what%20you're%20pushing%20data%20to%2C%20you%20could%20use%20a%20number%20of%20expressions%20to%20filter%20out%20the%20various%20parts%20of%20that%20string.%20I%20just%20entered%20an%20expression%20which%20is%20made%20up%20of%20Replace%20statements%2C%20just%20like%20you'd%20use%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ereplace(replace(replace(replace(triggerBody()%3F%5B'Title'%5D%2C'%22'%2C'')%2C'%5B'%2C'')%2C'%5D'%2C'')%2C'%2C'%2C'%3CBR%20%2F%3E')%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20case%2C%20the%20triggerBody()%3F%5B'Title'%5D%20is%20the%20Title%20field%20of%20the%20triggering%20list%20item.%20This%20Flow%20was%20triggered%20from%20a%20new%20item%20created%20in%20a%20SharePoint%20list.%20The%20Flow%20and%20the%20result%20can%20be%20seen%20in%20the%20attached%20screenshots.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20had%20in%20mind%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236067%22%20slang%3D%22en-US%22%3ERe%3A%20Results%20from%20a%20form%20-%20multiple%20answers%20-%20format%20in%20SP%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236067%22%20slang%3D%22en-US%22%3ESo%20unfortunately%20I%20don't%20really%20have%20the%20time%20to%20get%20the%20details%20on%20how%20to%20do%20this%20but%20maybe%20I%20can%20point%20you%20in%20the%20right%20direction.%20Look%20into%20using%20the%20built%20in%20functions%20listed%20here%20talking%20about%20string%20manipulation%20%3A%20%3CA%20href%3D%22https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fuse-expressions-in-actions%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Fuse-expressions-in-actions%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20are%20also%20actions%20you%20can%20pass%20data%20and%20or%20variables%20through%20to%20manipulate%20that%20data%20from%20across%20from%20forms%20before%20it%20gets%20sent%20into%20SharePoint.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861126%22%20slang%3D%22en-US%22%3ERe%3A%20Results%20from%20a%20form%20-%20multiple%20answers%20-%20format%20in%20SP%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861126%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20also%20having%20the%20same%20issue....%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F146733%22%20target%3D%22_blank%22%3E%40Jan%20Janssens%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20post%20the%20Flow%20steps%20they%20included%20to%20incorporate%20this%20to%20remove%20the%20unwanted%20characters%3F%20I'm%20struggling%20to%20see%20where%20and%20how%20to%20fit%20it%20in%20the%20Flow%20I%20have%20built...%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello, 

 

I'm feeding my sp list with answers from a form , by using a flow. Everything works well, but i'm curious for the following issue ; 

 

In my form i have several multiple choice questions, for which the user is allowed to select multiple answers. These answers are shown in my sp list, but it looks very messy. 

fex: There is a question ' what are your interests, and this is how the answers are shown in the list : 

["cars & motors","computers & IT,"games","art"]


Is there a workaround to display these answers in another way? 

 

I'm quite sure this is fixable with the Json formatting, but this is not my strongest skill. 

I don't need a full fix, just a push in the right direction or an idea how to fix this. 

 

(example in attachment ) 

 

Thanks

Jan. 

 

4 Replies
So unfortunately I don't really have the time to get the details on how to do this but maybe I can point you in the right direction. Look into using the built in functions listed here talking about string manipulation : https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/

There are also actions you can pass data and or variables through to manipulate that data from across from forms before it gets sent into SharePoint.


Depending on what you want to do and what you're pushing data to, you could use a number of expressions to filter out the various parts of that string. I just entered an expression which is made up of Replace statements, just like you'd use in Excel.

 

replace(replace(replace(replace(triggerBody()?['Title'],'"',''),'[',''),']',''),',','<br>')

 

In this case, the triggerBody()?['Title'] is the Title field of the triggering list item. This Flow was triggered from a new item created in a SharePoint list. The Flow and the result can be seen in the attached screenshots.

 

Is this what you had in mind?

Seems very promising!! :) I will test this and provide you with feedback.

many thanks for your time & effort Matt!

I am also having the same issue....@Jan Janssens 

 

Can someone please post the Flow steps they included to incorporate this to remove the unwanted characters? I'm struggling to see where and how to fit it in the Flow I have built... Thanks!