Dynamics Portals – Entity List Filters
Dynamics Portals Entity List is a easy and seamless way to port Dynamics 365 CE entity views to Dynamics Portals.
As an example, if I port ‘Active Contacts’ and ‘Inactive Contacts’ views to Portals, Portal User would start see all the Contacts based on his Web Roles.
Now lets implement a filter condition, to show only those Contacts where the logged in ‘Portal User’ (i.e., Contact) Company belongs to.
With out Filter Condition:
- I logged in to Portal as ‘Rajeev Pentyala’ whose Company is ‘Northwind Traders’ and having ‘Adminstrator’ Web Role.
- I can see all the Contacts irrespective of ‘Company’
With Filter Condition:
- With Filter Condition in place, I will see only those Contacts from my Company ‘Northwind Traders’
- To configure ‘Filter Condition’
- Open ‘Entity List’ form
- Under ‘Filter Conditions’ section, select ‘Account Attribute’ as ‘Company Name(parentcustomerid)’
- Open ‘Entity List’ form
Metadata Filter:
- What if we have to provide option to the ‘Portal User’ to filter the records based on field values?
- In below screen, Portal User has an option to filter records based on 2 Company Names (i.e., Northwind Traders, Adventure Works)
- This behavior can be achieved using ‘Metadata Filter’ option.
- In this article, I am going with ‘FetchXML Filter’ option, to provide filter options based on ‘Company Names’.
- Open ‘Advanced Find’ and prepare the filter.
- Download Fetchxml and copy only the <filter> tag
- Note: Add ‘adx:uiname’ property in <filter> tag to customize the filter label in Portal.
- Paste it in ‘FetchXML’ field and Save
- Notes:
- You can define more than one ‘Metadata Filters’.
- Refer article for detailed usage of Filters.
🙂
Categories: CRM, Dynamics Portals
Tags: Dynamics Portal, Entitylist, filter, Metadata Filter
Leave a Reply Cancel reply
Stats
- 1,558,539 hits
Tweets
- RT @ManuelaPichler_: I suffered a concussion last week, and I'm so glad to see this video is actually REAL and not just something my brain… 4 days ago
- RT @TaikiYoshidaEN: Awesome to see we have a shiny new public facing website for Power CAT! 😻😻😻 microsoft.github.io/powercat/ #PowerApps #PowerA… 1 week ago
- RT @ravichada: 🎥 The demo video is ready now. Do check out the Dataverse Security Roles risk assessment tool in action. Leave a comment or… 1 week ago
- RT @ManuelaPichler_: CoE kit but make it more fluent-y #comingsoon https://t.co/kcSzPqwZhM 1 week ago
- New Blog Post: C# Basics | Why Interfaces rajeevpentyala.com/2023/01/07/c-b… 4 weeks ago
Join 400 other subscribers
Top Posts
- Auto generate new GUID for ‘uniqueidentifier’ column in SQL Table
- [Step by Step] Postman tool with Microsoft Dataverse Web API
- Power Apps component framework (PCF) - Beginner guide
- [Code Snippet] Custom Workflow Activity with Input and Output Params
- [Step by Step] Connecting to Azure SQL Server using OLEDB Connection from SSIS
- [Step by Step] Power Apps Portal - Configure Global Search
- [Step by Step] Model-driven apps | In-app notifications
- Power Platform - Pass json collection from Canvas App to Power Automate
- God Mode - Level Up - Dynamics 365 Chrome Extension
- [Step by Step] Model Driven App | Grids | Navigate to custom page on row click
How to display the text of the option set value instead of ID?