Skip to main content

Notifications

Community site session details

Community site session details

Session Id : H5tnpYU4qu6EKDKUfuCf3Z
Power Automate - General Discussion
Answered

get items filter multiple conditions

Like (0) ShareShare
ReportReport
Posted on 2 Dec 2021 22:47:41 by
 
 

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

  • joef Profile Picture
    on 03 Dec 2021 at 12:18:44
    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 Profile Picture
    9,266 Super User 2025 Season 1 on 03 Dec 2021 at 06:45:07
    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 !

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

๐ŸŒธ Community Spring Festival 2025 Challenge Winners! ๐ŸŒธ

Congratulations to all our community participants!

Warren Belz โ€“ Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Communityโ€ฆ

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
rpersad Profile Picture

rpersad 16

#2
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

Overall leaderboard
Loading started