Announcements
I want to create a combo box in power apps which should drop down missing values between two columns in two tables in Excel
For example
Table 1
Column A
1,2,3,4,5,6,7,8
Table 2
1,5,7,8
So my combo box should display
2,3,4,6
Pls help me out
Hi @Nandha ,
Something like
Filter( Table1, Not( ColumnA in Table2.ColumnA ) ).ColumnA
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Thaaaaaaaaaaaaannnnnnnksssssss !!!!!! A lottt mannn the solution was infront of me the whole time i was searching on Chatgpt like an idiot wasted my 2 days just for this 8 words of fx formula
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 534
WarrenBelz 416 Most Valuable Professional
Valantis 306