Unanswered

Filter gallery by current user

(0) Share

Report

Posted on by Tomjoh92

HI!
I want the gallery in the app to only show the informartion typed in by the current user.

Can i use this on the item property on the gallery? Filter('Timeregistrering'; User().Email = User().Email))

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Shanescows 2,218 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you explain a little better what you are trying to do? I am sure we can accomplish it I just don't want to steer you wrong because I am not exactly sure what you want.

Does the gallery already contain a field with the user's email address that we can filter against?
Did they just enter this info or could they have done it at any point?

Shane
Tomjoh92 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm trying to make an app where employees can register their work hours. They check in and out and provide some information. This goes back to my excel sheet and make a paycheck.

I want the employees to only see their own data, not all the others.

I've made a text box in the check in label with User().Email and that provides correct email without me typing it anywhere so i'm guessing it finds automatically when you sign up on powerapps on the phone.

When i tried to type function i suggested i didnt get any error messages, but its a bit hard to try it when i dont have acces to an another e-mail yet.
ThatAPIGuy 925 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tomjoh92

You will need to have a column in the excel sheet like "UserEmail" , where you will have to collect the User().Email, so every record that is created can be mapped to the user.

Now when filtering you can use Filter('TimeRegistering',UserEmail=User().Email)

To test it out, you can create some dummy records in the excel sheet some random email ids defined in the UserEmail column. This way, when you check in , you can see if all your records are shown or not.

Hope this helps.!