Dataverse Filtered combobox

(0) Share

Report

Posted on by Imoale

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 with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
Imoale 4 on at

Like (0)

Report
Copy link

Link copied!

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!!!

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No