Filter Array not filtering

(0) Share

Report

Posted on by AW-28111537-0

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?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (0)

Report
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

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
AW-28111537-0 2 on at

Like (0)

Report

,I tried the new filter array and it still will not filter out Won or Lost

Screen Shot:

The second method i'm not sure how to work as I already have a filter query set for field_10 so that it reminds the account manager 7 days before expected close date of the opportunity

Screen shot:

I keep scratching my head on this one, just cant seem to figure it out.

Was this reply helpful? Yes No