Unanswered

Filtering for multiple conditions and a dynamic column name

(0) Share

Report

Posted on by cm230002

Hello - I'm creating a flow that's generating push notifications based on data in an Excel workbook, and trigger in a SharePoint list. The Excel workbook contains users who will receive the notifications, based on either their Country, Region on Territory (depending on what's selected when creating the SharePoint item, and there could be a single or multiple values to filter in the corresponding column).

First Name	email	Country	Branch	Territory	Region
Michael	Michael@fakeemail.com	US	US114	US114M	NAMER
Daniel P	Daniel@fakeemail.com	US	US107	US107J	NAMER
Charles	Charles@fakeemail.com	US	US114	US114H	NAMER
Roman	Roman@fakeemail.com	AR	AR101	AR101A	LATAM
John	John@fakeemail.com	US	US114	US114H	NAMER
Matias	Matias@fakeemail.com	AR	AR101	AR101A	LATAM
Sergio	Sergio@fakeemail.com	AR	AR101	AR101A	LATAM
Abel	Abel@fakeemail.com	AR	AR101	AR101A	LATAM

These are the 2 fields in SharePoint:

The "Approver_Level" field would determine which of the 4 columns to filter in Excel, and the "UserListFilter" will have the filter values.

In the first example, we would filter by the "Branch" column for US114 or US117, and the push notification would go to:

First Name	email	Country	Branch	Territory	Region
Michael	Michael@fakeemail.com	US	US114	US114M	NAMER
Daniel P	Daniel@fakeemail.com	US	US107	US107J	NAMER
Charles	Charles@fakeemail.com	US	US114	US114H	NAMER
John	John@fakeemail.com	US	US114	US114H	NAMER

In the 2nd, we would filter the "Territory" column for US114M or US107J, and the push notification would go to:

First Name	email	Country	Branch	Territory	Region
Michael	Michael@fakeemail.com	US	US114	US114M	NAMER
Daniel P	Daniel@fakeemail.com	US	US107	US107J	NAMER

And so on....there are ~10000 users in the Excel file, across dozens of countries, hundreds of branches, etc.

In an earlier version of the Flow as I was developing it, I have everything working except for dynamically selecting the column to filter.

The Compose is splitting the "UserListFilter" field by ';', and the Initialize Variable turns it into the varUserFilter variable that's used in the @ contains formula - @contains(variables('varUserFilter'),item()?['Territory'])

My first attempt was to initialize another variable to replace ['Territory'], but either that doesn't work or I can't get the syntax right with it.

**NOTE the change to the first variable name, this is correct

@contains(variables('varFilterValues'),item()?['varFilterColumn']) returns no values, even with data that matches:

If it helps, I've added Select Query in the List Rows Present action to only select the email, employee ID and varFilterColumn columns from Excel, so now varFilterColumn will always be the 3rd column in the array - so that could be used in the @contains formula (Column = 3) instead of the variable.

Here's the full flow if it helps - sorry for the long post and please help I'm at my wits end on this...

Chris

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

Interesting, I will take a look later today

Was this reply helpful? Yes No
cm230002 7 on at

Like (0)

Report

Thanks.

I also do realize that I could achieve the end result with a series of conditions (if varFilterColumn = Territory then filter the Territory column else of varFilterColumn = Branch...etc.,) but I'm hoping to keep this flow more concise, and it seems that what I'm trying to do should be achievable, which is why I haven't gone down the Conditions path just yet.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
Something like this?

Approvers

[ {"FirstName": "Michael", "Email": "michael@example.com", "Branch": "US114", "Territory": "US114M", "Region": "NAMER"}, {"FirstName": "Daniel P", "Email": "daniel@example.com", "Branch": "US107", "Territory": "US107J", "Region": "NAMER"}, {"FirstName": "Charles", "Email": "charles@example.com", "Branch": "US114", "Territory": "US114H", "Region": "NAMER"}, {"FirstName": "John", "Email": "john@example.com", "Branch": "US114", "Territory": "US114H", "Region": "NAMER"} ]

SingleLevel

{"Level": "Branch", "Filter": "US114;US117"}

Filter array

From

outputs('Approvers'

Filter

split( outputs('SingleLevel')['Filter'], ';' )

contains

item()[outputs('SingleLevel')['Level']]

Reesult

[ { "FirstName": "Michael", "Email": "michael@example.com", "Branch": "US114", "Territory": "US114M", "Region": "NAMER" }, { "FirstName": "Charles", "Email": "charles@example.com", "Branch": "US114", "Territory": "US114H", "Region": "NAMER" }, { "FirstName": "John", "Email": "john@example.com", "Branch": "US114", "Territory": "US114H", "Region": "NAMER" } ]

Was this reply helpful? Yes No
cm230002 7 on at

Like (0)

Report

Amazing, this worked 100%.
I was able to address both dynamic values in the step where I define the level and filter properties (and was able to remove a variable further upstream because the split I was using is now in this step.

Thank you so much!!

Was this reply helpful? Yes No