web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter list recursivel...

Power Apps

Unanswered

Filter list recursively with multiple lookup values

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi

Here is my list,

Company (multiple lookup) User (Person) Role (String)

A,B,C U1 R1

A,C U2 R1

D,A,C U3 R2

E, F U4 R3

On starting application, I retrieve row linked user connected, for example U1 --> OK

Based on row found, I have A,B,C Company

How can i retrieve all User based on values linked (A, B, C) Company ?

In my case, the type is table and i can't filter table with table

Any Idea please ?

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DRO29612961 ,

Do you mean that you want to filter U2,U3?

Please try this.

Distinct(Ungroup(ForAll(["A","B","C"] As C, Filter(List,C.Value in Company.Value)),Value),User)

Best regards,

Rimmon
DRO29612961 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks you, it works !

Join the conversation