CRMJettyBack to crmjetty.comContact us
Menu
Docs / Guides

CRMJetty Portal

Works with
Docs / Dynamics 365

Dynamics 365 Customer Portalv6.3.0

Docs / Salesforce

Salesforce Customer Portalv6.3.0

Docs / Business Central

Business Central Portal

Guides / Lists

How to Add Filters to Portal List Views

5 min readUpdated
Short answerIn Design → Lists, edit the list, open a field's Settings and select Enable for Filter, then select Save and publish the list. Portal users can then filter the list by that field. For lookup fields you can also set a Data Load workflow and Lookup Global Access.

Filters let portal users narrow a long list to the records they need, for example cases with a certain status or orders for one account. You choose which fields can be filtered in the list builder, field by field.

Before you start

Make a field filterable

  1. Go to Design → Lists.
  2. Select the three dots (…) next to the list, then select Edit.
  3. Select the Settings icon on the field you want portal users to filter by.
  4. Select Enable for Filter.
  5. Select Save.
  6. Repeat for each field.
  7. Select Publish.
Field configuration panel in the list builder with Enable for Filter selected
Field configuration panel in the list builder with Enable for Filter selected
Field configuration panel in the list builder with Enable for Filter selected
Field configuration panel in the list builder with Enable for Filter selected

Portal users now get a searchable filter option for each of these fields on every page that shows the list.

Note: In older versions this option is called Add to Filter’s list.

Note: You can’t filter on a field shown as an image. If Show as Image is selected for a field, Enable for Filter is disabled.

Filter by a lookup field

When the field is a lookup and Enable for Filter is selected, extra settings appear. Use them to control which values the filter offers.

Limit the values with a workflow

  1. In the field’s settings, select Workflow Setting.
  2. In the Data Load drop-down, select a workflow. Only workflows with the Load Data action type for the field’s target entity are listed.
  3. Select Save.
Workflow Setting for a lookup field with the Data Load drop-down open and the + icon
Workflow Setting for a lookup field with the Data Load drop-down open and the + icon
Workflow Setting for a lookup field with the Data Load drop-down open and the + icon

To create a workflow from here, select the + icon. The Add Workflow page opens with the entity already selected.

Show all values

Select Lookup Global Access to show all records of the related entity in the lookup filter, regardless of other filters or restrictions. For example, with Lookup Global Access on a customer lookup, the filter lists all customers.

Important: Lookup Global Access can show portal users records outside their own account. Turn it on only when every portal user who sees the list may see all those values. Otherwise, limit the values with a Data Load workflow.

Choose the fields a lookup shows

Custom Lookup View sets which fields of the related entity a lookup displays, and in what order.

  1. In the lookup field’s settings, select Custom Lookup View.
  2. In Custom Lookup Settings, select the related entity. Its primary field, such as Account Name, is added first and stays at the top.
  3. Add up to 4 more fields, such as Account Rating.
  4. Arrange the fields in the order you want.
  5. Select Save.

A custom lookup view holds up to 5 fields: 1 primary and 4 additional. Field names appear in the portal user’s language, or in English if no translation exists.

Add filters on the List widget

The List widget on a page has two more filter options. Open the page in Design → Page Builder and select the Settings icon on the List widget.

Setting What it does
Enable Global Access Lets portal users see global data, not only their own records. Portal users get a filter to switch between My Records and All Records.
Enable Global Filter Connects the list to a global filter on the page. Select a Data Field (for example Created On or Modified On) and the Lookup Field to filter on (Business Central: a single Select Global Filter Field). The Global Filter widget is available on selected plans; see How to Filter All Dashboard Widgets at Once.

Select Save, then publish the page.

Filters only narrow what a portal user can already see. To decide which records load in the first place, use a data loading workflow. See How to Apply Workflows to Portal Widgets.

Troubleshooting

Enable for Filter is disabled: Show as Image is selected for the field. Image fields can’t be filtered.

Workflow Setting doesn’t appear: The field isn’t a lookup, or Enable for Filter isn’t selected.

Your workflow is missing from the Data Load drop-down: Only workflows with the Load Data action type and the field’s target entity are listed. Check both in Workflow Management.

Portal users don’t see the filter: Publish the list after you change it, and make sure the page uses that list.

Did this solve it?No, contact support