Display all the data of the teams you belong to in a drop-down.

(0) Share

Report

Posted on by Lopez_0090

I am using the following data with Sharepoint List as the data source.

2021-10-06 233510.jpg

User1 and User3 belong to only one team, so it is simple, but User2 belongs to two teams, so I want the report names of the two teams to appear in the drop-down.

The value in the User column will be the same as the value obtained from the PowerApps "User().Email", so you can use the account you signed in to PowerApps to filter the teams.

2021-10-06 233914.jpg

For example, in the case of User2, I have acquired the teams "X" and "Z" to which User2 belongs, but I do not know how to use them to display the report names of "Z" and "X".

Please, can you give me some good ideas and methods?

Best regards,

Lopez

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
It sounds like you want to check which team(s) a user is a member of, and then generate a list of all reports applicable to those teams? If so, here's how I would do it:
Clear(colTable); ForAll(Distinct(Filter(colTeams, User = User().Email),Team) As userTeams, ForAll(Filter(colTeams, Team = userTeams.Result) As aReport, If(Len(LookUp(colTeams, Team = userTeams.Result && aReport.User = User().Email, Team)) > 0, Collect(colTable, { User: User().Email, Team: userTeams.Result, Report: aReport.Report } ) ) ) )
This needs to go in a behavior formula, such as OnVisible or OnSelect, and generates a collection that contains the table applicable to the currently logged-in user.

Hope that helps,
Bryan
Lopez_0090 87 on at

Like
a
(0)

Report
Copy link

Link copied!
@BCLS776
I apologize for the delay in replying.
Thank you so much!
I was able to display the data for the team I belong to based on your answer.

However, we have an additional requirement and want to switch the view depending on whether the user is a team manager or not.
Specifically,
Display all the data of the team for which you are the team manager.
If not, only data created by you will be displayed.

The data is displayed in Gallery, and the Team to be displayed is selected by a drop-down.
* User2 can only select "X" and "Z" teams, User3 can only select "X" teams

Is it possible to switch the data displayed depending on whether the user is a manager or not in this way?

Best regards,
Lopez
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Yes, this is possible and this is another many-to-many relationship between managers and teams, so the code will have a similar structure to the first sample I posted. The one difference: you will need an If() statement to decide which piece of code to run, depending on whether you are looking for a manager view or not. I am going to let you have the first crack at building this code (now that you have a guideline), but we'll be here in case you get really stuck.

First thing though, how do you decide in your app who the managers are? Do you test the current logged-in user against the list of managers? If so, consider an expression like this for your If() statement:

If(!IsBlank(LookUp(ManagerList, User = User().Email)), // Put code applicable to the manager profile here , // Put code applicable to the non-manager profile here )

Bryan