Fetch team members from D365 team in canvas app combobox

(0) Share

Report

Posted on by Poweruser32490

114

I have created a team in D365 which has around 30 users. May i know how to fetch those users from D365 team in canvas app combobox?

I am querying Teams dataverse table, but i undetrstand its not possible directly. We need to use team membership table, but i cant trace this table.

I even tried below piece of code but it doesnt work. May i know how to fetch the users from D365 in canvas app?

ComboBox Items

Filter(
    Users,
    "XXXX-XXXX-XXXX-XXXX" in ShowColumns(
        LookUp(
            Users,
            'User Name' = Office365Users.MyProfileV2().userPrincipalName
        ).'Teams (teammembership_association)',
        'Team'
    )
)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Ram Prakash Duraisamy 5,846 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

based on your code it will return only one value, try using below code to achieve the same

Filter(
Users,
"XXXX-XXXX-XXXX-XXXX" in
ShowColumns(
'Teams (teammembership_association)',
'Team'
).Team
)

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No
Suggested answer

Raymen Deol 75 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Your assumption about the data being in the team membership table is correct. This is a intersect or relationship table created to accommodate the many to many relationship between the Users and Teams tables. I don't believe you can directly query this table from a canvas app.

Please try the formula below, I tested it to ensure it works and follows best practices from the following Microsoft Learn article:

Option Sets and Many-to-Many Relationships for Canvas apps - Microsoft Power Platform Blog

This should work for both the Classic and Modern Combo box controls

Set the items field to:

ForAll(

First(Filter(Teams, name="YOUR TEAM NAME GOES HERE")).Users,

{ Text: 'First Name', Value: 'First Name' }

)

Replace with your team name and ensure that the app is connected to the Teams and Users table datasource.

Another solution for this would be to use power automate to retrieve a list of users for a specific team.

Please let me know if this works or if you need more assistance.

Thank you,

1 people found this reply helpful.

Was this reply helpful? Yes No