Answered

Building HTML (string) from ForAll

(1) Share

Report

Posted on by iskguy

402

I need to loop through a ForAll and compose some HTML that is going to be used in an HTML control. I have the following:

UpdateContext({FinalizedRecords: "<h4><strong><u>BOOKINGS</u></strong></h4>"});
ForAll(
 JBRecordsToFinalize,
 Collect(
 JBRecords,
 "<p><strong>" & LookUp(
 ConsumerRecords,
 ThisRecord.ClientID = 'Client ID',
 Name
 ) & " " & ThisRecord.ClientID & "</strong></p>"
 )
);

If I want to concatenate FinalizedRecords (the header) and JBRecords, I get an error about expecting Text. Is JBRecords not text or am I missing something? Thanks for the help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on at

Like (3)

Report
you should use concat, unless you need JBRecords to be a collection you can use later, forall is slow if your just making an html list

UpdateContext({FinalizedRecords: Concatenate("<h4><strong><u>BOOKINGS</u></strong></h4>", Concat(JBRecordsToFinalize, "<p><strong>" & Lookup(ConsumerRecords,ClientID = 'Client ID',Name) & " " & ClientID & "</strong></p>"))

The code above should produce an html string that can be used to display all records in JBRecordsToFinalize without creating an extra collection and running a forall. Let me know if that helps

Was this reply helpful? Yes No
iskguy 402 on at

Like (2)

Report

Thanks for this information!

Was this reply helpful? Yes No