Share
ReportI 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?
All responses (
Answers (
85
