Hi Team,
I have just received a request from a Client,
They require me to build an App whereby I can filter by selected Column Name and thereafter by data within that column,
My first filter would be to select the column which I want to search on
My Second filter would be to search by the text I have entered
I am able to successfully read in the field names and have a list box with names, I am having trouble with trying to filter
Eg.
Filter 1: Select Company No
Filter 2: "456"
| Name | Company No | Status |
| ABC | 123 | A |
| DEF | 456 | A |
| GHI | 789 | D |
| JKL | 000 | D |