web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Filter array

(0) ShareShare
ReportReport
Posted on by 10

I am having trouble filtering my data. I am using a flow to create a table. The data needs to be filtered down to 3 specific sites that have the status 'Cancelled'
My current flow will create the table but it will not filter down to my 3 sites. Please see my Filter array formula I have used below and a snip of my flow. I have tried it in the filter query of the "Get Items" action but get an automatic fail.

 

@Anonymous(equals(item()?['Site'], 'Name'), equals(item()?['Site'], 'Name'), equals(item()?['Site'], 'Name'))

 

Can you please help me so I am able to filter to the 3 unique names?

snip.png
Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,551 Super User 2025 Season 2 on at

    looks like you entered the code in the "dynamic content"  tab rather than the "write your own code"  tab.

  • chelsea4 Profile Picture
    10 on at

    Where do I select that option?

  • lbendlin Profile Picture
    8,551 Super User 2025 Season 2 on at

    lbendlin_0-1701908724362.png

    You want to be in the "Function"  section.

     

  • chelsea4 Profile Picture
    10 on at

    Can you tell me what is wrong with this? I appreciate your help this is very helpful

    snippp.png
  • lbendlin Profile Picture
    8,551 Super User 2025 Season 2 on at

    or() only works with two parameters.  Interesting that you didn't get an error message.   Use nested or's 

     

    or(a,or(b,c))

  • chelsea4 Profile Picture
    10 on at

    Sorry this is my first time using filter array

    Screenshot 2023-12-06 164506.png
  • lbendlin Profile Picture
    8,551 Super User 2025 Season 2 on at

    use nested or's

     

    or(contains(...),or(equals(...),equals(...)))

  • chelsea4 Profile Picture
    10 on at
    Screenshot 2023-12-06 170757.png
  • lbendlin Profile Picture
    8,551 Super User 2025 Season 2 on at

    I cannot help you if you keep sending blacked out screenshots. Post a clear text version of the code, with sensitive information removed.

  • chelsea4 Profile Picture
    10 on at
    Screenshot 2023-12-06 171551.png

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard