Skip to main content
Community site session details

Community site session details

Session Id : zpY0WAxmZvfBJVzI7mhzYS
Power Automate - Building Flows
Answered

Form Responses HTML Table - RowSpan Dynamic Help

Like (0) ShareShare
ReportReport
Posted on 7 May 2020 19:14:43 by 53

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.

  • v-alzhan-msft Profile Picture
    on 11 May 2020 at 09:38:26
    Re: Form Responses HTML Table - RowSpan Dynamic Help

    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.

  • Verified answer
    CrispinSteele Profile Picture
    53 on 08 May 2020 at 12:14:39
    Re: Form Responses HTML Table - RowSpan Dynamic Help

    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

  • v-alzhan-msft Profile Picture
    on 08 May 2020 at 02:49:16
    Re: Form Responses HTML Table - RowSpan Dynamic Help

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete