Notifications
Announcements
I would like to filter a Power Apps Gallery depending on a specific manager (e-mail) - ex. john.doe@tesla.com. But somehow it doesn't work. How do I have to ajust the items property/formula. You only find examples where it is about the current user.
The goal is that the manager only sees the tasks(items) that are relevant for him.
However, I would like to use the e-mail from my manager for test purposes.
Filter('Mitarbeiter Onboard Tasks','NotificationSentTo' = "john.doe@tesla.com")
I am grateful for any help
Greetings
hey @bob_taylor_pp
can you try this:
Filter('Mitarbeiter Onboard Tasks', NotificationSentTo.Email = "john.doe@tesla.com")
Let me know if my answer helped solving your issue.If it did please accept as solution and give it a thumbs up so we can help others in the community.Greetings
Hi @bob_taylor_pp
You may apply below code, if any manager present, it will return the manager email value:
Unfortunately, it does not work. I have already tried various things. I get errors every time. Could it be that the authorizations in the sharepoint itself are not sufficient to filter the data accordingly?NotificationSentTo is a simple text column with the corresponding e-mail addresses of the respective managers.
what kind of column is the NotificationSentTo? have u already tried to delete the single quotes? single quotes are normally used when u have a space in between of column names.
so instead of 'NotificationSentTo' use NotificationSentTo
I have now considered another column to make it easier
Aufgabenbesitzer is a column of the type person. I would like to filter the whole gallery now only by a person (manager) who has the corresponding e-mail.
Hi,
You may try:
Set(manager, IfError(Lower(Trim(Office365Users.ManagerV2(User().Email).mail)), "no_manager"));Filter('Mitarbeiter Onboard Tasks', Lower(Trim('NotificationSentTo')) = manager)
While testing, make sure that the logged-in user has a manager available (also ensure the connection to Office365Users is established). If errors persist, break down your screen items individually to identify where the error is originating from.
Refresh the database and check if errors persist. The 'NotificationSentTo' column should be present in the 'Mitarbeiter Onboard Tasks' database.
have you tried my example from above? using the person type column you would need to reference the .Email property of the person field like this:
Filter(DataSource, Aufgabenbesitzer.Email = "manager@example.com")
is that working?
Thank you very much for your help.I think I may have explained it too badly. The goal is that the manager finds its task(items) filtered via Power Apps. I wanted to test this with the e-mail from my manager. To have his view, so to speak.
Unfortunately, it is still not working. Could it be due to the permissions in the sharepoint itself for my user (account)?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Kalathiya 372 Super User 2026 Season 1
WarrenBelz 303 Most Valuable Professional
MS.Ragavendar 238 Super User 2026 Season 1
