web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Transferring a table o...
Power Apps
Answered

Transferring a table of Azure AD group IDs into a table of the group's name

(0) ShareShare
ReportReport
Posted on by 14

Hello,

I'm developing an app, in which the user the ability to choose a MS user from a combobox, and with a button press, all the Azure AD group names would appear in an another combobox. But currently I have a hard time of transferring the table of group IDs into a table of group names. Using ForAll, I have tried to concatenate the table into a string with semicolons separating the IDs (and then transferring this string into a table using split()) but this hasn't worked. I have also tried, 

ForAll(UserAzureADGroups,Substitute(UserAzureADGroups,Value,AzureAD.GetGroup(Value).displayName)); (this returns 'An error has occured' during running the app). I have also tried appending the group names into an another table using ForAll(), but haven't figured out how to do that.

 

I am using AzureAD.GetMemberGroupsV2(), which returns a table group IDs that the chosen user is a part of. Is there a possibility to transfer these values into group names already at this step? My syntax looks like 'AzureAD.GetMemberGroupsV2(UserID,false).value'

 

If anyone has any suggestions how to implement this kind of app, I would more than thankful.

Categories:
I have the same question (0)
  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @LasseNordqvist,

    Do you want to convert the group id into group name?

     

    Please try the following formula:

    ClearCollect(
     AllGroups, 
     AddColumns(
     AzureAD.GetMemberGroups(User().Email,false).Value, 
     "GroupName",
     AzureAD.GetGroup(Value).displayName
     )
    )

    vqiaqimsft_0-1690343379341.png

     

     

  • LasseNordqvist Profile Picture
    14 on at

    Thank you @v-qiaqi-msft, this resolved my issue and I was able to make a combobox with all the group names!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard