Display Users from a Specific team in gallery

(0) Share

Report

Posted on by CU24120349-0

Hi,

I do have a new requirement where i have to show the users who are a part of the team-A in a gallery. I found that the two tables user and team were maintaining a N:N relationship and they dont have any lookup fields in those tables. Can anyone help me out with this.

Note: Here the team it self a entity in the power platform environment not the Microsoft Teams.

Thanks in advance.

Categories:

Connectors

General Questions

Using Apps Using Formulas

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Mark Nanneman 989 Super User 2025 Season 2 on at

Like (1)

Report

Display Users from a Specific team in gallery

One way to do this is create a view on the Users table for the team, then use this view to filter in your Canvas App.

1. Create a view on your users table and name it

2. Edit filters

3. Click "Add a related table"

4. Scroll down to the bottom for the N:N tables and find Team

5. Add a row and select "Team" as the first property

6. In your Canvas App Gallery, filter Users by the view you just created.

If this helped you, please click "Does this answer your question" and give it a like to help others in the community (+ close the ticket)!

Power Platform Developer | LinkedIn: Mark Nanneman | Blog: Power Stuff | YouTube: Mark's Power Stuff |

Was this reply helpful? Yes No
CU24120349-0 4 on at

Like (1)

Report

Display Users from a Specific team in gallery

@Mark Nanneman, thanks for the quick response.

Unfortunately I can't create new view for the user table my client cant allow me to do that, but I can able to get the users from the specific team using this expression: "LookUp(Teams, 'Team Name' = "QA").'Users'"

Here I'm facing new problem when I refreshed the data source "Teams" table it is showing an error as "Error with detecting the data source Teams. Please remove and re-add it.". I added the Teams for multiple times but when ever i refresh the page the same error is populating again and again.

Was this reply helpful? Yes No
Mark Nanneman 989 Super User 2025 Season 2 on at

Like (0)

Report

Display Users from a Specific team in gallery

There you go, that's a good work around!

Where are you seeing the error? Can you post a screenshot?

And what do you mean by refreshing the page--

do you mean each time you load the app in play mode, or each time you navigate to the creen, or do you have a refresh action?

Was this reply helpful? Yes No
CU24120349-0 4 on at

Like (0)

Report

Display Users from a Specific team in gallery

Error will be at the power apps studio,

While coming to the refreshes, 1)When i made the changes, saved the page, published the page and refresh the browser in powers apps studio.

2)when try to refresh the data source of Team table.

I have to remove the team table from the data source and have to add it for each time i made the refresh in the power apps studio. I do have the System Administrator security role

Was this reply helpful? Yes No