How to filter a picklist

Hi, I created table 1 with a picklist to table 2, but I want to filter the picklist values to jut those where table2.field = a certain value

Microsoft Edge Clipping (16∶50∶03)

So I tried adding a filter formula into a rowlink formatted as a filter. I tried a few things, using =FILTER(... and without without the source field ID but couldnt find a way that works.

Any pointers would be greatly appreciated.


I needed one value from my Types table to kick off an automation. Here is the filter I used:



@PaulBappoo the first argument in the filter formula is just a table. Remove the column reference.


=filter(BusinessPartners, ...

Awesome, thanks both, worked a treat

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.