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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / LIST ROWS DATA VERSE G...
Power Automate
Answered

LIST ROWS DATA VERSE GETTING UNNECESSARY DATA

(0) ShareShare
ReportReport
Posted on by 46

Hi,

So I am building a flow that get entries based from these info from my data query.

cr69c_province eq 'BATANGAS' and cr69c_municipality eq 'LIAN' or cr69c_municipality eq 'CALATAGAN' and cr69c_typeofacquisition eq 'TO BE IDENTIFIED' and cr69c_projecttag eq 'BAT-3'

However, I am getting some rows which have other values that doesn't satify my query.

jonahinguito_0-1708311211180.png



jonahinguito_1-1708311239249.png
What could be the possible error in my filter query?

Thansk,

 

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

    Hi @jonahinguito ,

     

    Please try:

     

    cr69c_province eq 'BATANGAS' and (cr69c_municipality eq 'LIAN' or cr69c_municipality eq 'CALATAGAN') and cr69c_typeofacquisition eq 'TO BE IDENTIFIED' and cr69c_projecttag eq 'BAT-3'

     

    Best Regards,

    Bof

  • jonahinguito Profile Picture
    46 on at

    Fortunately, it worked. Should i enclose expressions containing "or"?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard