Filter Array For Two excel list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone

In my my flow I've have two list

"Employee List " List & Attandance list

I've a column in my Employee List as Emploee ID & in Attandance List as User ID

When my flow runs I need to take out all the employee ID 's which are not available in the User ID in a excel file

union(body('Select_from_Employee_list'),body('Select_from_Attendance'))

@or(not(contains(body('Select_from_Employee_list'),item())),not(contains(body('Select_from_Attendance'),item())))

The problem is the output of the filter array is not the unique value from the Employee List it provides an whole list some random numbers form Employee List

These are two list I need to check ,

The output should I recieve from the filter array is this But I 'm getting differrent Values

Could anyone please help me to fix the issue

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Chriddle 8,515 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Function union(array1, array2) returns all items of both collections (unique). If you input this into the Filter, you also get user ids, if they are not in the employee list.
If you want to filter the employee list, you should use this as input - or union(body('Select_from_Employee_list'), json('[]')) if you want unique items - and filter for not(contains(body('Select_from_Attendance'),item()))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi , Thanks For the reposne , I've updated the query ,But it is showing the following error

"
"Flow save failed with code 'WorkflowRunActionInputsInvalidProperty' and message 'The 'inputs' of workflow run action 'Filter_array_6' of type 'Query' is not valid. Property 'where' must be a template language expression.'.

Could You please help me to fix this error "

Was this reply helpful? Yes No
Chriddle 8,515 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
An example:
Since the arrays come from Compose actions here, they are addressed in the filter action with outputs(...).
Of course, if you use Select actions, you must use body(...).

Filter inputs:
{ "inputs": { "from": "@union(outputs('Select_from_Employee_list'), json('[]'))", "where": "@not(contains(outputs('Select_from_Attendance'), item()))" } }

Filter output:
[ { "name": "Jim" } ]

Was this reply helpful? Yes No