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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,347)