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

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

 

View solution in original post

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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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