Solve string to array in Word doc in PowerAutomate
Budget: $30 – $250 AUD
Currently working on a Power Automate workflow cannot get text string into word document.
We have one flow collecting data and storing data, and one flow generating Word documents from the data collected.
The data collection flow takes data from a Jotform as a string separated by breaks '<br />', which is then stored as a string in a single cell in an Excel sheet in OneDrive for business - so far so good.
The Word generating flow is meant to collect the data from the flow above and break down the variable text string into a list or an array AND then use it in a Repeating Section Content Control in the Word template, such that each item separated by '<br />' is in a different line or cell. This is the step we need help with!
Example inputs and outputs:
Inputs (Excel):
Option 1<br />Option 2<br />Option 3
Outputs (Word):
- Option 1
- Option 2
- Option 3
I will do the work but I need someone to advise how to do this step by step (screenshots and instructions based on example).
Budget AUD 30 to AUD 60
We have one flow collecting data and storing data, and one flow generating Word documents from the data collected.
The data collection flow takes data from a Jotform as a string separated by breaks '<br />', which is then stored as a string in a single cell in an Excel sheet in OneDrive for business - so far so good.
The Word generating flow is meant to collect the data from the flow above and break down the variable text string into a list or an array AND then use it in a Repeating Section Content Control in the Word template, such that each item separated by '<br />' is in a different line or cell. This is the step we need help with!
Example inputs and outputs:
Inputs (Excel):
Option 1<br />Option 2<br />Option 3
Outputs (Word):
- Option 1
- Option 2
- Option 3
I will do the work but I need someone to advise how to do this step by step (screenshots and instructions based on example).
Budget AUD 30 to AUD 60