Skip to main content

Notifications

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

302.PNG

 

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

Comments

*This post is locked for comments