Answered

How can we filter record on portal based on logged in user?

(0) Share

Report

Posted on by CRMadmin45

Dear Folks,

I need your help on Power App Portal.
I have created a power app portal from a blank with the background is CDS, in CDS I have created one custom entity with 10 records.
Now, I have 2 user one is admin and another is CDS user.
I have created entity list and added entity list to the web form, now I wanted to show all list records to admin but not to the CDS user on portal. (i.e. the CDS user will only be able to see his own record).
So how can we filter records based on logged in user?

Thanks in advance..!

@nhayduk , @OliverRodrigues , @Ashish2012

Categories:

Power Apps portals

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (1)

Report

hi, yes you can achieve that using two entity permission records: https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/assign-entity-permissions
1 entity permission (admin) - set to global and associate the Admin web role
2 entity permission (authenticated users) - set to contact and associate your contact lookup
make sure to check your entity list for "Enable Entity Permissions"
with the above settings the admin would see everything, the authenticated only records associated to their own user (Contact).. and anonymous user won't be able to see any data

------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
CRMadmin45 7 on at

Like (0)

Report

Hi,
As refereed to your solution, I have created the two entity permission records please find attached snip.
also, I have enabled the entity permission on the entity list and added the web role to the entity permission but still,
it is not working.

Thanks..!

@OliverRodrigues

Active Entity Per...

Enable Entity Per...

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

your setup looks pretty much the same as mine
did you clear the cache?
did you associate the web roles to your entity permissions?
what's the behavior in your portal? are you able to view all the records? no records? only own records?

Was this reply helpful? Yes No
CRMadmin45 7 on at

Like (0)

Report

Hi,
Just now, cleared the cache and It works.

Thanks a lot, Cheers..!

Was this reply helpful? Yes No