web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint list not re...
Power Automate
Answered

Sharepoint list not recognizing boolean values

(0) ShareShare
ReportReport
Posted on by 6

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

Categories:
I have the same question (0)
  • Verified answer
    v-chengfen-msft Profile Picture
    on at

    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

    vchengfenmsft_2-1675909423742.png

    Here is flow

    vchengfenmsft_1-1675909357418.png

    Here is result:

     

    vchengfenmsft_0-1675909340333.png

     

     

    Best Regards

    Cheng Feng

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard