web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Build dynamic HTML tab...

Power Apps

Answered

Build dynamic HTML table in htmltext control from a sp list

(0) Share

Report

Report

Posted on by RoniR

11

Hello,

Appreciate some assistance on this.

I am building a report (Shipping data) in my powerapps using an html template etc.

I reached a point where i have to generate a table that hold this information:

<table>

<tr>

<td>No of Packages</td>

<td>Description of Contents</td>

<td>Cargo value / est. price ($)</td>

<td>Gross Weight in Kg</td>

<td>Measurements (LXWXH) in cm</td>

</tr>

<tr>

//dynamic data

</tr>

</table

I have the shipment information stored in a SP list called Shipments

The shipment details are stored in a SP list called Shipment Details with RefID column the ID of the Shipment.

The client requires to view this information in a screen before sending it for print/pdf (which is something i can handle later on.

I am using an HTML Text control.

Not sure how to perform this action.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

victorcp 2,350 Moderator on at

Like (3)

Report
Hi,
you have to use ForAll to iterate over each row to create the new rows. It will be something like this:
"<table> <tr> <td>No of Packages</td> <td>Description of Contents</td> <td>Cargo value / est. price ($)</td> <td>Gross Weight in Kg</td> <td>Measurements (LXWXH) in cm</td> </tr>" & Concat( ForAll( 'Shipment Details', // Sharepoint list, "<tr> <td>" & <> &"</td> <td>" & <> &"</td> <td>" & <> &"</td> <td>" & <> &"</td> <td>" & <> &"</td> </tr>" ), Value ) & "</table"

replace <> with the corresponding info in sharepoint

Was this reply helpful? Yes No
RoniR 11 on at

Like (0)

Report

Muito obrigado

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report

TMJ!

Was this reply helpful? Yes No

Join the conversation