cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joef
Continued Contributor
Continued Contributor

get items filter multiple conditions

 
 

Hi All,

Can someone please tell me why my and condition below thinks the data in the "Title" column is the column name? 

I added single quotes, double quotes, I tried with a cap T, All caps, all lower...

 

I get the below error:

"Column 'Blah' does not exist. It may have been deleted by another user.   "

 

Blah is the data in the column not the column name.  

I am using the "Title" column...

 

 

BadAndCondition.jpg

 

TIA,

Joe

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Super User
Super User

@joef 

Because this is the ODATA query logic 😊.

Your formula should look like:

field_1 eq 'dynamicValue1' and Title eq 'dynamicValue2'

Please take care that the text column type values needs to be compared with string values and in PowerAutomate string values are delimited by quotes.

Hope it helps !

View solution in original post

2 REPLIES 2
gabibalaban
Super User
Super User

@joef 

Because this is the ODATA query logic 😊.

Your formula should look like:

field_1 eq 'dynamicValue1' and Title eq 'dynamicValue2'

Please take care that the text column type values needs to be compared with string values and in PowerAutomate string values are delimited by quotes.

Hope it helps !

View solution in original post

joef
Continued Contributor
Continued Contributor

Thank you!!  Yes I had it backwards I was quoting the Title not the dynamic 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (3,374)