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

Conquer the Clock: Time Management for Sales Teams using Dynamics 365 CRM

In the fast-paced world of sales, time is a precious commodity. Every minute spent on non-essential tasks is lost...

More Articles Like This

- Advertisement -spot_img