Concat & Filter to show a List in a Tooltip in PowerApps (Canvas)
USE CASE
I had a requirement to show a list of the customers in a Tooltip filtered by the same city where they live. In a Gallery, we show a list of all cities where our Cub Cake online store sells its products.
DATA
In this example, I am using the Customer Table from the Dataverse. This has basic contact information: Full Name, Address, and Email.
DESIGN
FORMULA
"Customers from the City of " & ThisItem.Result & ":" & Char(10) &
Concat(
Filter(
Customers,
City = ThisItem.Result
),
'Customer Full Name' & Char(10)
)
>>> NOTE: this code in the ToolTip property of the Label in the Gallery that shows the City Value
Resources
Concat Function
*This post is locked for comments