Forum Discussion
Results from a form - multiple answers - format in SP list
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 question...
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!
