web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Combo Box, names from ...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 76

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:
I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    154,540 Most Valuable Professional on at

    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

     

  • StaceyGriffeth Profile Picture
    76 on at

    @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.

  • WarrenBelz Profile Picture
    154,540 Most Valuable Professional on at

    @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

  • StaceyGriffeth Profile Picture
    76 on at

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

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 545 Most Valuable Professional

#2
Haque Profile Picture

Haque 314

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard