(Tables and variable names are changed to be general. The logic of the flow should still be the same)
I am running a flow that lists rows from a Dataverse table, that we can call "Users" (this is a custom table). The list row action uses a filter query based on a multi-select choice column in that table. The possible options are "0", "1", and "2". Here is roughly what the table looks like:
| Users |
Option(s) |
| A |
0,1,2 |
| B |
0,1,2 |
| C |
0,1 |
| D |
0 |
| E |
1 |
| F |
2 |
| G |
0 |
The filter query I have in Power Automate is something like:
During runtime, it evaluates to:
contains(cb838_options, '1')
When I run the flow with option 0, it correctly filters for the 5 rows with 0. When I do option 2, it correctly filters for the 3 rows with 2.
However, running it with 1 does not filter at all, and it always grabs all 7 rows. I am stumped here because it gives no error message, and I don't see why it does this issue with 1, but not 0 or 2.
