
Announcements
Im building this flow to return a csv file populated with only items containing certain attributes. the attributes on the list are Yes/No columns. However, in power automate when I use the "Get Items" function and filter using "Attribute1 eq 'true'" it returns nothing. But, when I filter using "Attribute1 eq '1'", it returns properly. This wouldn't be an issue except that the manual input from power automate gives true/false. Please advise
Hi @Tshaw ,
When its a Yes/No field you want to filter query it for when its true you use the not equal to operator "ne" and not "eq".
I made a template for your reference:
Here is list
Here is flow
Here is result:
Best Regards
Cheng Feng