web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate get items filter multi...

Power Automate

Answered

get items filter multiple conditions

(0) Share

Report

Report

Posted on by joef

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...

TIA,

Joe

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (4)

Report
Copy link

Link copied!
@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 !

Was this reply helpful? Yes No
joef on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation