Gallery filter based on logged in user email address

(0) Share

Report

Posted on by Angry_Sys_Admin

181

Hi.

I have an app which allows users to log their hours with a gallery where they are able to view (just the galley) the entries they have made.

On the Items tab of the gallery I've used the following coder to return the results unique to the logged in user:

LookUp(Hours, 'Email Address' = User().Email)

This did appear sort of work. As I'm testing this, I made 3 entries using using my AD Account and email address, when I refreshed the data source, only one item was showing in the gallery instead of 3.

I haven't had to make a gallery like this before so what am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Pstork1 69,573 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Two potential issues with the code you are using.

1) Lookup() will only return one record even if there are more than one that meet the criteria. It always returns the first one it finds. You want to use Filter() not lookup().

2) Using User() inside the statement will make it non-delegable so you'll never get all the entries if the list gets large. But if you store the email in a variable and use that he statement is delegable.

Use this instead

Set(UserEmail, User().Email);Filter(Hours, 'Email Address' = UserEmail)

Was this reply helpful? Yes No
Angry_Sys_Admin 181 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 Thank you for your solution.

I set the variable in the on OnStart properties for the app and then the filter on the gallery, all appears to be working.

Was this reply helpful? Yes No
Pstork1 69,573 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

That is a more efficient way to do it, but I didn't want to confuse you with the reference to app.onStart so I just did it in one line.

Was this reply helpful? Yes No