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)));
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.