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
Column A
1,5,7,8
So my combo box should display
2,3,4,6
Pls help me out
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
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.
MS.Ragavendar
10
LC-26081402-0
6
EE-04041031-0
4