You’re not using the new Text1 or Text2 columns you showed earlier.
Don’t mess with the screen filter. You don’t need a filter there. Just let it default to the first row of the table. That’s where your choice values will be written. You only need the filter for the collection.
You are showing the filter for the first choice component. Don’t filter the choice components. Don’t filter the screen. Only apply a filter to the Collection component only.
Your filter on the collection should be using the screen values of your Text1 and Text2 columns because that where the selected choices are being written. (ie. Filter where Gender equals Screen>Text2)
Why are you trying to filter by ClientID instead of Status? Your first choice title is Status, so why not try to find a matching status instead of ClientID.
I would use IS instead of INCLUDES. Otherwise you risk matching partial words. For example, ‘male’ and ‘female’ both INCLUDE ‘male’, but only ‘male’ IS ‘male’ and ‘female’ IS NOT ‘male’.
Why aren’t you filtering by Text1 and Text2? Right now you are filtering by whatever status and gender the first client in the table happens to have (assuming the screen is attached to the first frow in the table). You are not filtering by your choice selections. You are writing your choices to Text1 and Text2. Use them to appropriately filter the Gender and Status in your collection. Filter by the selected choices…not by the gender and status of the first client.
