Hi i made an app and i have a sharepoint list where there is a column which is a look up column of another list , I want to make a dropdown that only list the items that arent existing in that column, can anyone help me?
Solved! Go to Solution.
Hi ,thanks a lot for your fast responses i apreccie it.
I tried with the filter and making the update in the DataCard but it still doesnt show up any value.
I have tried to put the ShowColumns in the last filter that you send me but it prompt me a error in this comma .
Hi @Expolio ,
I missed the important step---edit the DisplayFiled of your Combobox to ["Number1"]:
Then for Items property, use this:
Filter(list10,Not(Number1 in AddColumns(list8,"lookupvalue",Value(lookup1.Value)).lookupvalue)).Number1
For the Update property of DataCard, use this:
Okey now it show me the numbers in the dropdown but it show me all the registers ,i only want the registers that are not in the lookup1 column like in the show columns version that you send me the other day.
Hi @Expolio ,
Is these numbers correct?
And all numbers display in the dropdown?
If yes, re-try below method which I mentioned before(also refresh your datasource):
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!