cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Expolio
Helper II
Helper II

discarding existing elements in a dropwdown

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?

13 REPLIES 13

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 .

captura.jpg

Hi @Expolio ,

I missed the important step---edit the DisplayFiled of your Combobox to ["Number1"]:

valbaimsft_4-1626233234745.png

 

Then for Items property, use this:

Filter(list10,Not(Number1 in AddColumns(list8,"lookupvalue",Value(lookup1.Value)).lookupvalue)).Number1

valbaimsft_2-1626233178922.png

For the Update property of DataCard, use this:

valbaimsft_3-1626233201485.png

Best regards,

Allen

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.

Expolio_0-1626247986510.png

 

 

Hi @Expolio ,

Is these numbers correct?

valbaimsft_0-1626332889642.png

And all numbers display in the dropdown?

If yes, re-try below method which I mentioned before(also refresh your datasource):

valbaimsft_1-1626332993076.png

Best regards,

Allen

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,951)