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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multiple filters in a ...
Power Automate
Unanswered

Multiple filters in a Filter Array

(0) ShareShare
ReportReport
Posted on by 674

Hello,

 

So I googled this but I am having trouble following what people are saying, and perhaps it's a bit dated. I am building a flow to keep tabs on our O365 licenses for when they get to 0, we know to order more. However there are a lot of licenses so I want to filter out the array.  I can do one license easily enough, by doing Advanced mode, and I do as follows : 

 

@And(greater(item()?['prepaidUnits']?['enabled'], 1),contains(item()?['skuPartNumber'], 'DESKLESSPACK'))

 

However, I want to filter for DESKLESSPACK, STANDARDPACK, and ENTERPRISEPACK for the SkuPartnumber to keep tabs on those 3 licenses, how can I add in the other two here? Not sure on the syntax, thanks.

Categories:
I have the same question (0)
  • Verified answer
    Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at
    Re: Multiple filters in a Filter Array

    Hi @CharlesBrewer 

     

    Does this help ?

     

    @And(greater(item()?['prepaidUnits']?['enabled'], 1),contains(createArray('STANDARDPACK','ENTERPRISEPACK','DESKLESSPACK'),item()?['skuPartNumber']))
  • CharlesBrewer Profile Picture
    674 on at
    Re: Multiple filters in a Filter Array

    @Nived_Nambiar 
    Hey looks like that's working, much appreciated!

  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at
    Re: Multiple filters in a Filter Array

    You are welcome 🙂

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard