Hi Guys,
Complete novice so don't know if can work. I have built a flow which is functional (thanks to the forum) - but does not work how I want. The user completes a MS Form which lists all issues identified (from 1 to 15 issues). The flow collects the responses, puts them into an array and then filters the array so only issues identified are populated. This array is then added to an html table and saved as a word and PDF document - which is emailed to the user. Great 🙂
However, this only shows the problems - not the solutions. I was thinking of appending an extra column to the JSON array to cover this - however some problems have more than 1 solution and therefore is plain HTML some of the columns would need a rowspan element added.
Here is an table example of what I would like to show (without any format):
<html>
<table border=5 cellspacing=0 cellpadding=2 style='border-collapse:collapse;border:none'>
<tr>
<th>Internal Code</th>
<th>Non-Compliance found</th>
<th>Policy Booklet</th>
<th>Section Number</th>
<th>What needs doing?</th>
</tr>
<tr>
<td rowspan=4>1</td>
<td rowspan=4>Problem A</td>
<td>Book A</td>
<td>Chapter 6; Schedule 3</td>
<td rowspan=4>Whatever the pages say. If in trouble ask the forum!!</tr>
<tr>
<td>Book B</td>
<td>Chapter 1</td>
</tr>
<tr>
<td>Book Z</td>
<td>Appendix 4</td>
</tr>
<tr>
<td>Book X.</td>
<td>Diagram X</td>
</tr>
<tr>
<td>2</td>
<td>Problem C</td>
<td>Booklet A2</td>
<td>Pages 123-145</td>
<td>Add details to log once complete</td>
</tr>
<tr>
<td rowspan=2>3</td>
<td rowspan=2>Problem J</td>
<td>The Management Handbook.</td>
<td>Some Chapter</td>
<td rowspan=2>Ring Central switchboard to isolate circuit</td>
</tr>
<tr>
<td>Book XX.</td>
<td>Chapter 5</td>
</tr>
</table>
</html>
Obviously the filtered array will be different every time. Is there someway to add a rowspan argument in styling (Compose Operation?) or failing that if i added the multiple items in one container can I force a <br> between them or replace ";" with <br> for example.
Does this make sense?
Thanks for any help
Cris.
Hi @CrispinSteele ,
I have replied in the link below:
https://powerusers.microsoft.com/t5/Building-Flows/Download-PDF/td-p/554752
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Alice,
Thank you for coming back to me. I have now worked around the issue and found a solution which works for me. In short I just added \r within the JSON Array to force a new line.
My question is now different and please let me know if I have to repost.
I am using Word for Business and have created my word document and created the file sharepoint and also converted it to PDF.
The final part of my jigsaw is how do I get the PDF document to open and download on to the users local machine? I guess it may be something to do with HTTP and GET - but I do not have a clue.
Thanks again to all for any help
Cris
Hi @CrispinSteele ,.
Would you please share a screenshot of your flow?
Do you want to add a column to the Array and than add the new array to the html table?
I suggest that you could provide the Array and explain the extra column that you would like to add, if you share an example we could better understand you and provide a proper solution.
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2