web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Complex Gallery with t...
Power Apps
Answered

Complex Gallery with two tables

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have two excel tables

 

Request(email, some_other_info)

and

Person(email, some_other_info)

 

There are two apps. One for everyone and one for admins. Request table is public and shared with everyone, Person table is private and shared only with admins

 

In App1 people create and manage requests.

In App2 admins manage request as well as Person table.

 

Here is what I have right now in App2:

To get all the district emails from Request table:

Distinct(Request,Email)

This gives me all emails.

In the gallery I have a hidden text label which I use to see if for this email Person exists.

HiddenLookup.Text property

If(IsBlank(LookUp(Person,ThisItem.Result = Email,Email)),true,false)

And then based on this hidden variable I either show info or that no user profile exists.

If(HiddenLookup.Text = "true","User Account Not setup",LookUp(Person,ThisItem.Result = Email,some_other_info))

 

Now, I want to have a gallery which only displays Distinct emails which do not appear in Person table.

What I though of putting in the Gallery Item property

 

Distinct(
    Filter(
        Request,
        IsBlank(LookUp(Person,Person.Email = Request.Email,Person.Email))
    ),
    Request.Email
)

This ofcourse does not work. How can I, in the formula, separate Email from Person table and Email for Request table?

Any ideas on how I could make this Gallery work, to display only distinct emails that are not found in Person table?

Categories:
I have the same question (0)
  • Verified answer
    v-micsh-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    You could write the formula in this way:

    Distinct(
     Filter(
     Request,
     not(Email in Person.Email)
     ),
     Email
    )

    See my testing results:

    31.PNG

     

    Adding some reference here:

    Operators and data types in PowerApps

     

    Regards,

    Michael

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard