Hello everyone! 🙂
I'm working on creating an automation flow in Power Automate that fills in a Word template using the "Populate Word Document" action. Specifically, I need to format answers from Microsoft Forms, particularly for questions with multiple choices. The output in the Word document currently looks like this: [“value1”, “value2”], but I want to format these answers into bullet points.
I've tried several methods, such as:
- Creating a variable with a new line, and using that in a 'join' action
- Using the `json()` function
- Replacing and splitting the values, and then using the new line variable
These approaches help in removing the square brackets and quotation marks, but I can't figure out how to insert new lines and format the answers as bullet points.
Additionally, I have seen that it's possible to use the `json()` function within an "Apply to each" loop to avoid creating a new "Compose" action for each answer from Microsoft Forms. However, I'm not sure how to implement this.
Could someone please provide guidance on how to:
1. Convert the multiple choice answers into a bullet point format within the Word template.
2. Use the `json()` function in an "Apply to each" loop to handle multiple answers efficiently.
Any help or examples would be greatly appreciated!
Thank you in advance for your support.
Best wishes,
Jules
