Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Filter Entity list based on a logged in contact field along with account



I am trying to filter the list of records that portal user can view. Right now its on the account scope of the portal user. In addition to it, filter should be applied based on the optionset field that is on the contact entity suppose "A".  I have the same option set field on the Entity B. so the filter should be entity A.option set value= entity B.optionset value.


Please suggest how to implement this to filter the existing entity list of the Entity B


Solution Sage
Solution Sage

Hi @deepthih 

You need to use fetchxml using liquid code in Entity List. You can add your custom filter in fetchxml as well as in liquid code.


Please refer below blog:

Just wanted to add webapi has been added as a preview capability to portals and that may be an alternate way to retrieve to fetchxml:

Hi @hardikv , Thankyou for your response, I have seen this post, And its building custom web template and fetch xml is appended to it instead of entity list. My requirement is to use the same web template and entity list.

Is there any way that i can add filters to the entity list directly? 

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.


Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,363)