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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Dataverse Filtered com...
Power Apps - Microsoft Dataverse
Answered

Dataverse Filtered combobox

(0) ShareShare
ReportReport
Posted on by Imoale 4

Hello everyone,

 

  I have three Dataverse for teams tables  

 

Team: ID, Name, Type,

Player: ID, Name, Position

TeamAssignment:  ID, PlayerID lookup), TeamID (lookup)

 

I want two combo boxes,

 

comboBox1:  items=Teams

 

I need comboBox2 to filter only the Name of the players for Team selected in comboBox1

 

I did not build the tables and do now want to alter them whatsoever (ie: add a TeamsID column) since they are quite large and important. 

 

Categories:
Microsoft Dataverse
I have the same question (0)
  • Verified answer
    Ami K Profile Picture
    Ami K 15,674 Super User 2024 Season 1 on at
    Re: Dataverse Filtered combobox

    @Imoale ,

     

    Consider the below:

     

    With(
 {//Filter the TeamAssignment table based on the selected team from the Combo Box. Then return the distinct Player IDs in that table
 _players: Distinct(
 Filter(
 TeamAssignment,
 TeamID.Name = ComboBox1.Selected.Name
 ),
 PlayerID.ID
 )
 },
 Filter(
 Player,
 ID in _players
 )
)

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

    Imran-Ami Khan

  • Imoale Profile Picture
    Imoale 4 on at
    Re: Dataverse Filtered combobox

    Thank you that worked, Issue is now that filtering in _Players is giving all string matches.  (As in result "1326" when I only wanted to match "26").  Thank you again!!!

  • Ami K Profile Picture
    Ami K 15,674 Super User 2024 Season 1 on at
    Re: Dataverse Filtered combobox

    Consider changing this line:

     

    ID in _players

     

    To:

     

    ID exactin _players

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

    Imran-Ami Khan

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans