PowerAutomate string into array to MS Word
Budget: $10 – $30 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 need someone to advise how to do this step by step (screenshots and instructions based on example).
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 need someone to advise how to do this step by step (screenshots and instructions based on example).