Answered

Nested Filters

(0) Share

Report

Posted on by EG-05090855-0

Hello dear power apps community,

I'm having a problem with filtering 2 lists against each other. I've got a list 1, where I have employee data and a list 2 where I have department data. Then I've got a list 3, where I collect likes from users of list 1 to users from list 2.

List 1

Employee data	Email
...	(functions as ID)

List 2

department data	departmentID
...	1 to N

List 3

Employee Email	departmentID
xxx@example.com	1 to N

I want to make a filter that finds an random element from list 2, that are not liked from the active user (list 3).

My try was to Filter(List2; IsBlank(LookUp(List3; Employee Email=Office365Users.MyProfil().Mail && DepartmentID=List2.DepartmentID)

But this last part doesn't really work, since I can't reference the first filter inside the LookUp.

For randomization I actually got an algorithm:

First(SortByColumns(AddColumns(Filter(See above);"Random";Rand());"Random")

It would be really helpful If someone found an solution for this problem. Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @Elias_Gda,

Are you trying to access the DepartmentID column from the current List2 filter record? Should this be the case, can create an explicit record scope via 'As':

Filter( List2 As Main; IsBlank( LookUp( List3; //Preferably the office365... value should be stored in a variable and the variable should be referenced 'Employee Email' = Office365Users.MyProfileV2().mail, DepartmentID = Main.DepartmentID ) ) )

Alternative in which you limit the amount of API calls:

With( { wList3Ids: Filter( List3; //Preferably the office365... value should be stored in a variable and the variable should be referenced 'Employee Email' = Office365Users.MyProfileV2().mail, DepartmentID = Main.DepartmentID ).DepartmentID }, Filter( List2; !(DepartmentID in wList3Ids) ) )

To get a random record, you could also use the Shuffle function:

First( Shuffle( //Filter statement (opt1) or With statement (opt2) ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
EG-05090855-0 38 on at

Like (0)

Report

That was it! I didn't know the functions "As" and "Shuffle", thanks for showing me

Was this reply helpful? Yes No