Answered

Gallary Screen fitlter for HR

(1) Share

Report

Posted on by Wei Ming Leong

313

Hi all,
Thank you for taking your time to read this.

i have this employee powerapp that i am making that have a browse screen, Admin screen and connected to a sharepoint list.
sharepoint list details are as :

this employee powerapp will have details of the employee to fill up information such as emergency contact, bank details, home address etc.
in browse screen gallery i found a formula that able to show the entry of the employee filled up.
Filter('Employee Information', 'Created By'.Email = User().Email)

But if the HR staff is keying all the information into the sharepoint list or powerapp, it will show the employee information of the HR staff keyed in as the formula is set base on created by such as like this:

How can i allow the browsescreen gallery to only show that employee to see his/her own details even it is keyed by other person?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Pablo Roldan 316 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
Base on your question you should use other field to filter by.
I notice there is a email field that should be unique Personal Email Adress
Filter('Employee Information', 'Personal Email Adress' = User().Email)
regards.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PabloRoldan ,

personal email address is employee email address which is like gmail.
i am not able to get it to work.

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like
a
(1)

Report
Copy link

Link copied!

i have tried using Filter('Employee Information', 'Employee Name' = User().FullName) and it work.

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
You can use this filter:

Filter('Employee Information', 'Employee Name' = User().FullName)

but problems exist with this as the users may share the same name.
I recommend you add a columns for their work email and then use:

Filter('Employee Information', 'Work Email Adress' = User().Email)

Was this reply helpful? Yes No
Wei Ming Leong 313 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AJ_Z,

for the first solution,
as long as it employee who fill up i dont have to worry i think as i set the form to automatically show their display name.

for the 2nd solution i will set work email to automatically input into the Form also.
thank you for the idea and solution.

Was this reply helpful? Yes No