web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Exclude items from Lis...

Power Apps

Answered

Exclude items from List1, which are there in List2 using Power App

(0) Share

Report

Report

Posted on by jyotiRajpurohit

18

HI,

I am working on Power Apps, so here I want to exclude items from List1 which are present in List2

Example

List1

1

2

3

4

5

List2

3

5

Using power app to get items like

1

2

4

here I am using Filter to exclude items, but having 2 issues here

Filter gives delegate Warning
It doesnt give Intellisense for list columns

Could you please help me in this

Thank You

@Anonymous

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jyotiRajpurohit,

In this case, in is necessary, which means that the delegation issue could not be avoided.

Further, modify your formula as below:

Filter(List1,!(ID in List2.ID)).ID

Note that the ID column in both list1 and list2 sharing the same ID.

Was this reply helpful? Yes No
jyotiRajpurohit 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft

I have applied this logic to exclude items from List1 but it gives Delegation Warning, coluld you please help me in that how can i overcome this.
I did use nested Filters function for this, but still it didnt work
Thank you
PREVIEW

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jyotiRajpurohit,

In this situation, this "in" operator is necessary, which means the delegation warning is inevitable.

Try to increase the rows limit to 2000 at max, this is operative currently.

Was this reply helpful? Yes No
jyotiRajpurohit 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft
Yes I already changed data rows limit to 2000 and after applied logic

Was this reply helpful? Yes No

Join the conversation