Power Community

Power Community

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

This post was originally published on this site

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement - Advertisement

Latest News

Enable Early Access Wave 1 2023 | Power Platform

Like every 6 months, enabling Early Access is one of the best things to look forward to as Microsoft...

More Articles Like This

- Advertisement -spot_img