Power Platform Community Forum Thread Details

I'm currently using the template GitHub - OfficeDev/microsoft-teams-apps-attendance: The Attendance Power App helps teachers record and save the attendance of students in their class. for attendances and I would like to use Dataverse rather than Microsoft List.

This app has a drop down list with all Entra ID groups I own, I was able to list the built-in table called "Teams" instead, which is the "Teams" I own in Dataverse.

However, I would like to list the members of each Team selected in the Drop List into the Gallery of this canva app.

Categories:

Microsoft Dataverse with Power Apps

pls try the following:

Dropdown Configuration: Use the Teams table in Dataverse to populate the dropdown with Teams owned by the user. Set the dropdown's Items property to Filter(Teams, Owner = User().Email)

Use the TeamMemberships table to list members of the selected Team.Set the gallery's Items property to Filter(TeamMemberships, TeamId = Dropdown.Selected.TeamId)

Pre-load data for Teams and Team Memberships using ClearCollect for better performance: ClearCollect(AllTeams, Filter(Teams, Owner = User().Email));
ClearCollect(AllMembers, TeamMemberships);

Update dropdown and gallery to use pre-loaded collections Dropdown: AllTeams Gallery: Filter(AllMembers, TeamId = Dropdown.Selected.TeamId)

let me know if you need more details.