Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Filter Array not filtering

Posted on 28 Nov 2024 15:55:33 by
Hi There,
 
I am trying to filter out by a choice column if the choice is either Won, or Lost, then using apply to each to send an email to the person that is assigned that opportunity.
 
The choice column name is "Status" but the actual name in Microsoft list is field_7

Screen Shot:
 
 
 
 
Here is a screen shot of the get items (which i know works because without filter array it just outputs all oppertunites to each account manager
 
 
Finally here is the apply to each with send an email (V2)
 
What am i missing,  why wont the filter array filter our Won or Lost opportunities?
  • Suggested answer
    EKarim Profile Picture
    EKarim 10,207 on 28 Nov 2024 at 22:31:10
    Filter Array not filtering
     
    Please try the following:
     
     
     
    @and(not(equals(item()?['field_7/Value'], 'Won')), not(equals(item()?['field_7/Value'], 'Lost')))
     
     
    field_7 is a choice column and is structured like this:
    {
        "field_7": {
            "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
            "Id": 2,
            "Value": "Won"
        }
    ...
    }
    
     
     
     
    Alternatively, turn off experimental settings, then edit the Get items action and add the following filter query:
    field_7 ne 'Won' and field_7 ne 'Lost'
     
     
     
     
     
     
    Ellis

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard