Unanswered

Looping Through a Collection

(0) Share

Report

Posted on by RH-25092337-0

All - I am having issue retrieving values from a collection. More specially, I have a requirement to retrieve the values of a collection and write them to an HTML table.

At present, I have the following and am stuck trying to figure this out. Any help would be greatly appreciated...the issue appears to be with my Forall statement. Here I am trying to iterate through the collection until it reaches the max (2 in this case) and write this value.

"<strong> Attendance Records: " & User().FullName & "</strong>" &
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & 
"<tr style='background-color:#efefef'>
<th>Date</th> 
<th><center> Time In </center></th>
</tr>" & 
"<tr>" & 
"<td>" & ForAll(Sequence(2),ThisRecord.Value) & " </td>" &
</tr>" &
"</table>"

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,049 Most Valuable Professional on at

Like (0)

Report
Hi RH-25092337-0

Try this format
"<strong> Attendance Records: " & User().FullName & "</strong>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'> <th>Date</th> <th><center> Time In </center></th></tr>" & Concat( FirstN( CollectionName, 2 ), "<tr><td>" & Text(DateFieldName,"dd/mm/yyyy") & "</td><td>" & TimeInFieldName & "</td></tr>" ) & "</table>"

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Verified answer

Wee Teck 45 on at

Like (1)

Report

The issue lies in the way you're using the ForAll statement within the HTML string. PowerApps doesn't directly support using ForAll in this context to iterate over a collection and embed it in a string.

You’ll need to manually concatenate the values from the collection into your HTML table. The best approach is to use Concat() in PowerApps, which allows you to iterate over a collection or table and concatenate its values into a string.

// Concatenate the rows for each record in the collection (assumed the collection is called 'AttendanceCollection')
Concat(
AttendanceCollection,
"<tr>" &
"<td>" & DateField & "</td>" &
"<td><center>" & TimeInField & "</center></td>" &
"</tr>"
)

Was this reply helpful? Yes No
WarrenBelz 153,049 Most Valuable Professional on at

Like (0)

Report

Hi RH-25092337-0,

Did you review what I posted - I believe it also addresses your requirement for the first two items only - what you accepted is basically a copy of my post missing this requirement.

Was this reply helpful? Yes No
RH-25092337-0 35 on at

Like (0)

Report

I accepted your post as you mentioned my missing ingredient: Concat.

I needed only to make use of the Concat function to iterate through my collection to write those values to my HTML table. Thanks.

Was this reply helpful? Yes No