How to use loops in HtmlText (Power Apps, SharePoint)

(0) Share

Report

Posted on by kjk4563

134

This is the code for HtmlText.

And the code below is connected to SharePoint.

"<div>" &
 Concat(
 Distinct(
 Table1.A, A.Value
 ), Value
 & 
 "<div style='padding-left: 150px;'>" &
 Concat(
 Distinct(
 Filter(
 Table1, 
 A.Value = "ID" // here
 ), B.Value
 ), Value & "<br>"
 ) &
 "</div>"
 ) & 
"</div>"

In the line 'here' as a comment in the code, "ID" is one of the Values of A.
What should I use instead of "ID" if I want to see all values in B that belong to Value in A?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
hey @kjk4563

try this:

<div> Concat( Distinct( Table1.A, A.Value ), Value & "<div style='padding-left: 150px;'>" & Concat( Distinct( Filter( Table1, A.Value = selectedAValue ), B.Value ), Value & "<br>" ) & "</div>" ) </div>

Here, selectedvalue should be replaced with the actual control or variable that holds the value from column A that you want to filter on.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No