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 / Fetch team members fro...
Power Apps - Microsoft Dataverse
Suggested answer

Fetch team members from D365 team in canvas app combobox

(0) ShareShare
ReportReport
Posted on by Poweruser32490 20
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
I have the same question (0)
  • Ram Prakash Profile Picture
    Ram Prakash 5,520 Super User 2025 Season 2 on at
    Fetch team members from D365 team in canvas app combobox
    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
  • Suggested answer
    Raymen Deol Profile Picture
    Raymen Deol 48 on at
    Fetch team members from D365 team in canvas app combobox
    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:
     
    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, 

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

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 624 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 381 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 225

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans