how to filter view of the list by current logged user

(0) Share

Report

Posted on by Erandi

265

hi,

i have created a view from the data verse table. Now i want to filter that records by logged user. but in the filter sections, how to handle it?

help me guys...@Fubar @Lucas001

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Sort by

AkshayShah 59 on at

Like (0)

Report
Copy link

Link copied!

Hi Erandi,
You have to apply table permission based on your requirement in the power pages.
Thanks,
Akshay shah

Was this reply helpful? Yes No
Erandi 265 on at

Like (0)

Report
Copy link

Link copied!

hi @Akshay_Shah ,i have set the table permission.
in here ,is there a way to filter by logged user?

Was this reply helpful? Yes No
Erandi 265 on at

Like (0)

Report
Copy link

Link copied!

@Akshay_Shah I have sent ss for setting the filter condition after applying table permissions with contact table.
but it is not worked ..the records are not loaded.? Is there any issue with me?

Was this reply helpful? Yes No
Fubar 8,487 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
to limit what the user can see altogether use Table Permissions

to limit a specific List you can use the Filter (as per Erandi's post above), but (if they shouldn't be seing anyone elses records, Table Permissions are the more secure option)

If the user is allowed to see other Contact records, you could create a View (in the view's conditions set a filter to Contact and contact will get replaced with the current logged in user)

If the user is allowed to see other Contact records, you could enable filters and set one of the Lookup filters https://learn.microsoft.com/en-us/power-pages/getting-started/add-list#filter-types (I am not sure if the Lookup filters are in the new interface yet if not you may need to do it from the Portal/Power Pages management app)

It depends on exactly what you need to do

Was this reply helpful? Yes No
Abhishek Bihani 45 on at

Like (1)

Report
Copy link

Link copied!

Hi @ERA ,

To filter view based on logged in user you have to do below steps:

1. Create Contact record as name 'Portal Filter'
2. Add filter condition in Owner filed & select Contact 'Portal Filter'.

Portal View automatically filter records based on logged in Contact.

Here is example:

Was this reply helpful? Yes No
Erandi 265 on at

Like (0)

Report
Copy link

Link copied!

hi @abhibihani
should i create new contact inside of contact list.right?

Was this reply helpful? Yes No
Abhishek Bihani 45 on at

Like (0)

Report
Copy link

Link copied!

Yes, please create new contact.

Was this reply helpful? Yes No
Erandi 265 on at

Like (0)

Report
Copy link

Link copied!

@abhibihani can you explain this .I didn't get it

Was this reply helpful? Yes No
Abhishek Bihani 45 on at

Like (1)

Report
Copy link

Link copied!

If you are using 'X' entity then ideally you should have one contact lookup to filter records based on logged in portal user/contact. If you have Contact lookup created then add that field in filter condition of view.

For e.g. Lead entity view having Contact lookup then add filter condition on Contact lookup & select newly created 'Portal Filter' as contact.

Was this reply helpful? Yes No