Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Filter, search and order a board

Add filters, a search bar and your own column order to an opportunity board, so each rep narrows a busy pipeline to the deals they need.

Forty deals on one board is a lot to scan. A rep preparing a call wants only new business from partners, or the one deal she is about to discuss, and has no use for the Closed Lost column. This page adds filters and a search bar above the board, and sets which stage columns appear and in what order.

Opportunity Kanban with a search bar and three filter menus above it, filtered to new business: 11 deals, column totals recalculated
Filtered to new business: the counts and totals follow the filter

Before you start

Steps

1

Choose the filter fields

Open the Kanban in the property editor. In Data Mappings, add fields to Filters: Type, Lead Source and Close Date. Drag them in the list to set their order on screen.

Each field becomes a filter menu above the board. Picklist fields offer their values, a date field offers a range. The filter mode a user can pick (Equals, Between and so on) follows the field type: see Kanban for the full list.

The column totals follow the filters: filter on Type = New Business and each Total shows the new business amount only.

2

Make the filters work together

Open the Filter section:

  • Use Cascading Filter Values: turn it on. Once a user picks a Type, the Lead Source menu only lists sources that have deals of that type. The menus list values, and their counts, from every opportunity in the org, not only the deals on the board, so a pick can still leave a column empty.

  • Picklist Filter Sort Order: Ascending (the default) sorts picklist values alphabetically. Default Order of Field keeps the order set in Setup.

  • Display As Popover: off, the filters sit in a row above the board. On, they move into one filter button that opens a popover, which saves room on a smaller screen.

Filter section of the Kanban property editor with Use Cascading Filter Values turned on
Cascading filters narrow each menu to what the other filters leave
3

In the Search section, turn on Show Search. Set Placeholder to something that tells users what they can type, for example Search deals by name, and pick a Position above the board.

Then, in Data Mappings, add Opportunity Name to Search Fields. Without Search Fields, the search looks in every searchable field of Opportunity, which matches more than users expect.

4

Set your own column order and hide a stage

Open Column Order Direction and set Direction to Custom. Columns Custom Order fills with every stage.

  • To reorder, drag the rows of the Columns Custom Order list. Users cannot move columns at runtime: the order you set here is the one they get.

  • To hide a stage, remove it from Columns Custom Order. Remove Closed Lost and lost deals no longer appear on the board.

A board grouped by an optional picklist (for example Lead Source instead of Stage) also gets a column for records with no value. Hide it with Hide Undefined Group in the Group By section, or rename it with Undefined Group Label. Grouping by Stage never adds one, because Stage is required.

5

Save and test

Save and run the flow. You should see:

  • a filter menu for each field, labelled with the field label (Opportunity Type, Lead Source, Close Date), and a search bar, above the board;

  • no Closed Lost column;

  • after picking New Business in Opportunity Type (the filter applies at once and a line under the search bar says how many items were found): only new business cards, column totals for those cards, and a Lead Source menu limited to matching sources.

Troubleshooting

A stage added in Setup does not show on the board

Direction is Custom, and the new value is not in Columns Custom Order. With a custom order, the board shows only the stages in that list. Add the value to the list.

The search bar is missing

Search Fields alone does not show it. Turn on Show Search in the Search section.

The search finds deals for the wrong reason

Search Fields is empty, so the search looks in every searchable field of Opportunity. Add only the fields users actually search on.

A filter lists values that return no card

Use Cascading Filter Values is off. Turn it on to narrow each menu to the records that match the other filters.

Was this helpful?