Hi all,
I created an entity table which stores company information including company name.
I want to show the company records in Power Apps portal filtering by login user's company.
Now it is showing all the records from entity in Power Apps portal. It should be showed only if the company name is matched login user's company name.
Would anyone know how I could achieve this?
Thanks in advanced for your help.
as per @EricRegnier you need to setup entity permissions correctly - In addition to what Eric has above - this includes setting Entity Permissions being required on the Forms etc (tickbox on the Entity Form, Entity List) and removing any Global entity permissions (one of these last 2 are why you have users seeing all records instead of no results, or just the records they are associated with)
Hi @ChanNT, sorry for the delayed response. You can achieve that will the same approach with entity permissions and entity view/form configuration. There are 3 ways depending how your Contacts relates to Companies:
Hope this helps!
Would it work to use the domain of the logged in user with Last and Split (at the @ symbol in User.Email() ), and then filter the datasource where the domain of the created by/modified by (also using Last and Split) fields match?
Pat
Hi @EricRegnier ,
Thank you for the advise.
But for my case, I want to show the company list filtering by organization/ company of the login users.
I tried out to filter by login user email and it works. But I don't want to filter by email since the records from company table are created by admin and they will be shown in the list if the portal user's company name is matched.
Hi @ChanNT,
This can be achieved with the following steps:
Hope this helps!
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1