cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
orohlste
Frequent Visitor

Turn contents of a Collection from a Form into HTML Issue

Hello!

 

I'm trying to create an HTML output that references my collection. It was working and bringing in my collection, but now it's no longer working. I am not getting an error message, so I'm not sure if something is wrong with my code. Below is an image of the portion where I reference the collection and the "LineItemX" is the name of the input. 

 

 

 

2 REPLIES 2
timl
Super User
Super User

Hi @orohlste 

I think it might be useful if you were to include your full formula. I assume that the formula you posted refers to the formula that's inside a ForAll loop, and that "LineItemX" are columns in your collection.

I've highlighted the obvious error. You should remove this extraneous tag in your code.

timl_0-1605212100585.png

 

 

orohlste
Frequent Visitor

@timl 

 

After looking at a similar post it sounded as if I wouldn't need to use a forall in power apps and that'd I'd be able to just run the concat. Let me know what you think of the whole statement and where I can add the ForAll

 

"<html>
<head>
<style>
table, th, td {
border: 1px solid black;
}
</style>
</head>
<body>

<h2> Material Return Form</h2>

<p>See below the items for return.</p>

<table style= width:100%>
<tr>
<th>Project PN</th>
<td> "& ProjectPNField_2 &" </td>
</tr>
<tr>
<th>Project WO</th>
<td>" & ProjectWOField_2 &" </td>
</tr>
<tr>
<th>Name of Project</th>
<td>" & ProjectNameField_2 &" </td>
</tr>
<tr>
<th>Name of Returner</th>
<td>" & ReturnerField_2 &" </td>
</tr>
<tr>
<th>Supervisor</th>
<td>" & ManagerField_2 &" </td>

</tr>
<tr>
<th>Return Date</th>
<td>" & DateField_2 &" </td>
</tr>

</table>

<p></p>
<p></p>

<Table style=width:100%>
<tr>
<th>Part Number</th>
<th>Part Description</th>
<th>Qty Returned</th>
<th>Serial Number</th>
<th>BOM</th>
<th>Line Item</th>
<th>Reason for RTN</th>
<th>Master ID</th>
</tr>
<tr>
" & Concat(MaterialCollection,
"<tr><td> "& LineItem1 &"</td>
<td> "& LineItem2 &"</td>
<td> "& LineItem3 &"</td>
<td> "& LineItem4 &" </td>
<td> "& LineItem5 &" </td>
<td> "& LineItem6 &"</td>
<td> "& LineItem7 &" </td>
<td> "& varRecord.ID &" </td>
</tr>")
&"

</Table>


</html>
"

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,045)