Answered

Combo Box, names from one SP List that aren't in another list

(0) Share

Report

Posted on by StaceyGriffeth

I have two Sharepoint Lists, A & B. I have a combo box which needs to list the names from List A which are not in List B. Additionally, it should only include names from List A which have a "Complete" (another field in the list) value of 'No' or 'false'. How can I do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 154,540 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @StaceyGriffeth ,

Assuming Complete is a Text field it would be something like this (note this is not Delegable) - with your actual field name

Filter( ListA, !(NameField in ListB.NameField) && (Complete = "No" || Complete = "false") )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
StaceyGriffeth 76 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz thanks so much for your reply! The list is now loading the correct Names. Do you know how I can also sort the list? I've tried SortByColumns but have not been able to get it to work.

Was this reply helpful? Yes No
WarrenBelz 154,540 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@StaceyGriffeth ,

Not sure how you used it in the code, but it

Sort( Filter( ListA, !(NameField in ListB.NameField) && (Complete = "No" || Complete = "false") ), YourSortField, SortOrder.De/ascendng )

would be

Was this reply helpful? Yes No
StaceyGriffeth 76 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz that did it! It is now sorting correctly. Thanks so much for all your help!

Was this reply helpful? Yes No