cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BHR
Helper II
Helper II

excluding existing records from table in powerapps

Hi All,

 

I have a combobox which is binding with Table1 while patching this combobox data loading into Table2(Having multiple columns).

 

I want to exclude already existing records in Table2(Having multiple columns) while binding data to combobox items.

 I tried below but not working as expected.

ClearCollect(Table3,Filter(Table1,Not("cre80_type" in Table2)));

 

Can someone please guide me.

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
CNT
Super User
Super User

@BHR You can see it working as seen below,

CNT_0-1638265472953.png

 

View solution in original post

7 REPLIES 7
CNT
Super User
Super User

@BHR You need to check for "cre80_type" in particular column in Table2, something like,

ClearCollect(Table3,Filter(Table1,Not("cre80_type" in Table2."cre80_type")));

Thanks for helping me @CNT ,

 

I tried with your suggestion but no luck. It was not excluding the existing record.

Is there any other way we can achieve this.

CNT
Super User
Super User

@BHR I'll need to see the formula, some sample data from both the tables and the result you are getting.

Hi @CNT , 

Please find the below details.

 

ClearCollect(collection1,Filter(Table1, ('view (Views)'.Name)).VALUE);

Value
A
B
C
D

ClearCollect(collection2,Filter(Table2,Id="custId").Type);

Type
B

 

Tried with this below code, It was not excluding the existing record.

ClearCollect(collection3,Filter(collection1,Not("cre80_value" in collection2.cre80_type)));

 

 

CNT
Super User
Super User

@BHR You can see it working as seen below,

CNT_0-1638265472953.png

 

Thanks for helping me @CNT ,

 

It was working with single column, what if we have more than 1 columns in both tables.

 

Thanks again.

CNT
Super User
Super User

@BHR It will still work.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,669)