I'm working on a flow that is triggered when a new item is created in a Sharepoint list.
I have a Compose action that includes HTML that I'm using to make a PDF report. One of the columns in my Sharepoint list includes a series of names separated by semicolons:
Person 1; Person 2; Person3, etc.
The column type is "multiple lines of text" (plain text). When I include that field in my HTML as dynamic content, I want it to be formatted with line breaks after each name instead of the semicolons, like this:
Person 1
Person 2
Person 3
Any suggestions would be greatly appreciated. Thanks.
Solved! Go to Solution.
Hi @T_A_M ,
Please find below steps.
1- Initialize variable - HTML
2- Compose action to hold semicolon values from your list. I have taken hard coded value
3- Loop over the person values
Input : split(outputs('Compose_-_Semicolon_Delimited_Value'),';')
split the compose value by semicolon.
4- Append value in string variable
5 - Now append the string outside of apply to each loop
6 - Add the above variable value in your html.
Output:
The entire flow
Thanks
Vivek Pande
If this post helps answer your question, please click on "Accept as Solution" to help others find it more quickly.
if you thought this post was helpful, please give it a Thumbs Up
Hi @T_A_M ,
Please find below steps.
1- Initialize variable - HTML
2- Compose action to hold semicolon values from your list. I have taken hard coded value
3- Loop over the person values
Input : split(outputs('Compose_-_Semicolon_Delimited_Value'),';')
split the compose value by semicolon.
4- Append value in string variable
5 - Now append the string outside of apply to each loop
6 - Add the above variable value in your html.
Output:
The entire flow
Thanks
Vivek Pande
If this post helps answer your question, please click on "Accept as Solution" to help others find it more quickly.
if you thought this post was helpful, please give it a Thumbs Up
That worked perfectly. Thank you!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
48 | |
18 | |
15 | |
13 | |
13 |
User | Count |
---|---|
61 | |
42 | |
24 | |
24 | |
19 |