You’re offline. This is a read only version of the page.
I'm sure that this has been covered before, but I'd really appreciate some help.
I've written a flow that will take information from a Form and put it into an Excel spreadsheet. This all works fine. The problem is that I have a number of multiselect answers in the Form which are coming across like this.... ["North America, "LATAM", EMEA"] and I want them to appear as North America; LATAM; EMEA. I think that means I need to convert an array to a string, but I'm not sure if that's correct or how to do it!
Thanks in advance for your help - I am very much a newbie at all of this!
Hi @Frannier ,
You can use the join() expression to achieve it. Here is a quick example using the same array provided by you:
In a string variable, I'm assigning the join() expression, but you can do it directly in your "Add a new row to a table" action:
In yellow, you have the array that must be joined; in green, you have the "separator" that will be used in this operation (in our case, a semicolon).
Here is the final result:
You can check more details about how to work with text expressions in Power Automate in this article that I wrote some months ago: http://digitalmill.net/2023/08/12/how-to-extract-and-clean-texts-with-power-automate/ .
There is also this another article that uses as example the same operation that you are trying to automate (add form answers to an Excel file, including from multiple choice fields): http://digitalmill.net/2023/07/31/using-dynamic-content-in-power-automate/
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
