web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Store Selected Azure A...

Power Apps

Answered

Store Selected Azure AD group members to a SharePoint list column

(0) Share

Report

Report

Posted on by muzzamal

102

I have dropdown that selects an Azure AD group based on a condition.

The members of the group are already stores in a variable using the code below.

Set(varL2opgcUsermembers, AzureAD.GetGroupMembers("b59ff3f6-31f7-45cd-bd1b-142e36dd3cb2").value);

I have a person type column in sharepoint (Allow multiple selection is enabled for this column).

When submitting the form, I want to store the members from the above variable to this column with display names of the members.

How can i achieve this?

Thanks in advance

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @muzzamal ,

I made a sample for you.

Patch(LIST11,Defaults(LIST11),{Title:"Test",Mult:ForAll(varL2opgcUsermembers,{Claims:"i:0#.f|membership|"&userPrincipalName,Email:"",Department:"",DisplayName:"",JobTitle:"",Picture:""})})

Best Regards,

Wearsky
muzzamal 102 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much ... but the submit button still shows an error.
Actually, I have several fields in the form so I disabled the formsubmit(form) before using the patch function.
is this causing the problem?
muzzamal 102 on at

Like
a
(0)

Report
Copy link

Link copied!

it worked.
Final code that worked is below:

Patch(TestList, // sharepoint list
Defaults(TestList), // sharepoint list
{Title:"Test",
GroupMembers: //sharepoint column name
ForAll(
varGroupMembers, //variable or collection where member are stored
{Claims:"c:0t.c|membership|"& userPrincipalName,
Email:"",
Department:"",
DisplayName:"",
JobTitle:"",
Picture:""})});

Join the conversation