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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How can I filter a 'Ad...
Power Automate
Answered

How can I filter a 'Add a new row' by an array value?

(0) ShareShare
ReportReport
Posted on by 114

I want to add a new row into dataverse, and I want to filter by an array value. For example if my array is [ [a,b,c], [d,e,f] ], in the filter i want it to be facility eq array[0][0]. I read that i can't use arrays but i have seen people post that they did it with a concat which didn't work for me.

Categories:
  • Rhiassuring Profile Picture
    8,692 Moderator on at

    Hi there, 

     

    Sorry, I don't understand. Are you trying to say that you want to filter "Facility" where it is equal to A, or B, or C, and also D, or E, or F? 

     

    You can't filter by an array, but, you can pull content from the array and then use that on your filter. But you'd need to extract it first.

  • bp3378 Profile Picture
    114 on at

    Sorry for the confusion.  Let's just say my array is arr[a,b,c].  I wanted to filter by 'a' so I tried putting this in a string variable: 

    facility eq 'variables('arr')[0]'

    Then putting that in the filter rows field in a List rows action.  But that did not work.  

  • SamLed Profile Picture
    2,340 Moderator on at

    Hi @bpw,

     

    You have to send it as expression:

    SamLed_1-1709250626062.png

    _____________________________________________________________

    If I have answered your question, please Accept the post as solution.
    If you like my response, please Thumbs Up.

  • bp3378 Profile Picture
    114 on at

    Can u show me what you have in your expression.  I think I tried that but still failed.  

  • Verified answer
    SamLed Profile Picture
    2,340 Moderator on at

     

    @bpw it is already available 😉

     

    SamLed_2-1709250680805.png

     

  • bp3378 Profile Picture
    114 on at

    Thank you it worked.  For some reason I thought I did this before but I probably did it differently.  Thank you so much waisted a half a day trying to figure this out 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 307 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 127

Last 30 days Overall leaderboard