News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion get items filter multi...

Power Automate - General Discussion

Answered

get items filter multiple conditions

Like (0) Share

Report

Report

Posted on 2 Dec 2021 22:47:41 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

All responses Img

All responses (2)

Answers Img

Answers (1)

joef on 03 Dec 2021 at 12:18:44

Like (0)

Report

Re: get items filter multiple conditions

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

CU-18081211-6 9,266 Super User 2025 Season 1 on 03 Dec 2021 at 06:45:07

Like (4)

Report
Re: get items filter multiple conditions

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard > Power Automate - General Discussion

#1

stampcoin 31

#2

SriniK 26 Super User 2025 Season 1

#3

Pstork1 22 Most Valuable Professional

Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans