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.

Before you start
Build the pipeline board first: Build an opportunity pipeline board with column totals. This page adds to that board.
Steps
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.
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.

Add a search bar
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.
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.
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
Related tutorials
Build an opportunity pipeline board with column totals: the board this page starts from.
Group cards into swimlanes with totals: split the same board by lead source.
Open a flow from a card action: act on a deal straight from its card.
Was this helpful?
