cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deepthih
Regular Visitor

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

Hello,

 

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

 

3 REPLIES 3
hardikv
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: http://dyn365apps.com/2017/09/14/dynamics-365-portals-liquid-templates-part-3-retrieve-data-using-fe...

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: https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-overview

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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,545)