Answered

LIST ROWS DATA VERSE GETTING UNNECESSARY DATA

(0) Share

Report

Posted on by jonahinguito

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.

What could be the possible error in my filter query?

Thansk,

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: LIST ROWS DATA VERSE GETTING UNNECESSARY DATA

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

Was this reply helpful? Yes No
jonahinguito 46 on at

Like (0)

Report

Re: LIST ROWS DATA VERSE GETTING UNNECESSARY DATA

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

Was this reply helpful? Yes No