Answered

How to get Azure Group in Power Apps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Guys,

I want to get the name of Azure Groups which I am member of. Below I will explain you more in which situation I am.

Currently I have a SQL table which is has a column called AZGroup. This column contains Group1, Group2 and Group3 as data.

In Azure Active Directory there are 3 Groups, Group1, Group2 and Group3. I am member of Group2 and Group3.

So what I want is that in my Gallery to filter to the column AZGroup and the Azure Groups which I am member of (Group2 and Group3). So the question is How can I get the Azure Groups dynamically to make a filter? The thing is I have more than 10 Groups in Azure and I have more than 20 members which there are member in several Groups.

Is there any functions or workaround thing to achieve this?

Thanks in advance!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to filter SQL table based on the groups that you belong to ?

If so, I suggest you use Office365 Groups connector.

You could get the list of the groups that you belong to by using this formula:

Office365Groups.ListOwnedGroups().value.displayName

So you could use this to filter your table:

Filter(tablename, AZGroup in Office365Groups.ListOwnedGroups().value.displayName)

Here's a doc about this connector for your reference:

https://docs.microsoft.com/en-us/connectors/office365groups/#listownedgroups_response

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft ,

Thanks for your response! Unfortunately I got an error when I tried the formule see you below.

And also you will find my Group on Azure Active Directory.

Thanks in advance!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Is there anybody else who can help me with this issue?

Thanks in advance!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft ,

I got now all my Groups from Azure which`s I am member of. As you can see in the attachment I have a Gallery which includes all the Groups from the current user. But I need to filter all the Items(Groups) in another gallery which will filter this to my SQL Table. So that I pick up all the items from my SQL table which matched with my Azure Groups.

The formula in my another gallery which filters to my SQL table looks like this, but AllItems does not work, but if I use Selected instead of AllItems then I only get the selected value, that is not what I want. Like I said I need to filter all the Groups.
Spoiler (Highlight to read)
Filter('[dbo].[test1]',groups= Gallery3.AllItems.Title2)
Filter('[dbo].[test1]',groups= Gallery3.AllItems.Title2)

Hopefully you can help me know!
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I solved this problem, with the following steps.

- Insert a button (ClearCollect(allgroups,AddColumns(AzureAD.GetMemberGroups(User().Email,false).Value,"GroupName",AzureAD.GetGroup(Value).displayName)))
- Insert a gallery then put the result of above collaction in the gallery(allgroups)
-Insert a gallery and then make a filter to above gallery and your source table (Filter('[dbo].[test1]',Owner in Gallery3.AllItems.GroupName))