Hi
I have a form that users can enter a multiple lines of text, up to 50 Lines. I would like to each line to an excel table. Is this possible?
Thank you it worked a treat
Hi @Skybluekid ,
You will need to transform your form question answer into an array and loop it. Check the process below.
Excel table
For this example, we will populate this empty table:
Dummy Text
For this example, I'm using the text below, stored in a string variable. In the following steps, you can replace the string variable for your Form answer dynamic content.
Step 1 - Split the text:
Initialize an array variable and store the following expression: split(variables('original_text'), decodeUriComponent('%0A')). This expression is splitting your text by line break:
The array will look like this:
Step 2 - Loop array:
Use your array as input to an 'Apply to each' loop. Inside the loop, insert an 'Add row into a table' action, populate the file and table details and, in the relevant field (in my case, 'value'), include the dynamic content of the 'Current item' from 'Apply to each' action:
Output:
After run the flow, this will be your output (the empty record at row 2 already existed when I created the table):
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.