List up members of Teams

[Murph_Metal]

Hi all !

I just started using Power Apps yesterday...

Please kindly give me advices on 2 questions.

I want to create an app that can list up members of the Team and export to an Excel sheet.

My idea : at first in the app, user can choose the Team from Teams which they own by dropdown list

Dropdown1 : Office365Groups.ListOwnedGroups().value

At first I want to list up the members on a table according to the id of Office365 groups selected by the dropdown list.

Question1.  I am not sure how to write, please correct my formula.

Filter(Office365Groups.ListGroupMembers(Dropdown1.Selected.id).value,User().Email in Email)

Question2. Is there a good idea to export the table to an Excel sheet ?

[gabibalaban · Accepted solution]

Hi @Murph_Metal ,

Question 1:

It's enough to use:

Office365Groups.ListGroupMembers(Dropdown1.Selected.id).value

Put this formula inside a gallery control Items property  and use labels inside gallery to see the extracted data.

Question 2:

Depends on what your objectives are. If you only want to see the extracted data is enough to use a gallery. 

[MKM]

Did you manager to solve this? Would love to see the solution