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.
Solved! Go to Solution.
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.
Hi @CNT ,
Please find the below details.
ClearCollect(collection1,Filter(Table1, ('view (Views)'.Name)).VALUE);
Tried with this below code, It was not excluding the existing record.
ClearCollect(collection3,Filter(collection1,Not("cre80_value" in collection2.cre80_type)));
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
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.