I've created a flow for MS Form to "Add a Row" in an excel spreadsheet (exactly the same as I created for last year.) It works, but on one of the columns, parentheses and quotes are being ADDED to the text. Why?
The data is then filtered out to other sheets for analysis based on the text in each column. When parentheses and quotes are added, then my analyses won't work.
How to fix?
Between your info, and this video, I got it to work.
https://youtu.be/l82nVlGwrio?si=0ehyyvEdVFDitk2Z
I really like the join/ json way. Much easier.
Thank you so much for pointing me in the right direction to find a solution!! 🙂
Thank you so much for trying to help me. But, I'm not sure where the compose comes in. I've looked at several you tube videos, and I am not able to get it right.
Any chance you could give me all the screen shots from after the Get response details? Putting that Expression directly into my Add a Row Into a Table didn't work.
Hi @slarson77
for that try this expression :
When using above expression, it looks like this:
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
I am using the easily clicked Dynamic content. I believe I've discovered the issue. That particular question has a "multiple answers" allowed. I think this is what's doing it. I don't know how to tell Power Automate to simply put a comma between the words IF and only if there's multiple answers. I assume I have to use expression, and script it out, but I'm not a programmer, so I'm stuck.
Hi @slarson77
does the data from form added to excel have such parentheisis, quotes etc ? have you checked the form dynamic content value added to flow ?
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌