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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 530

#2
WarrenBelz Profile Picture

WarrenBelz 459 Most Valuable Professional

#3
Haque Profile Picture

Haque 314

Last 30 days Overall leaderboard