web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Patch SP List with Gal...

Power Apps

Answered

Patch SP List with Gallery Users

(0) Share

Report

Report

Posted on by marney

77

Hi dear people!

Hoping to get some help 🙂

I have a gallery that is being populated with users from a combobox.

I've set the OnChange of the combobox to add users to a collection:

Collect(collectUsers, {Email:ppCombo.Selected.Mail})

My Gall is connected to the Collection: (Items=collectUsers).

I would like to patch the collection of users to a Person column in SP (column is called Member).

For example, I'm using ForAll:

ForAll(collectUsers, Patch('WalkTheWorld Team Members', Defaults('WalkTheWorld Team Members'), {Title:wtwform_1.LastSubmit.Title, MID:wtwform_1.LastSubmit.ID,

Member:....

(Ignore the wtwform bit above).

Its that last bit I need help with please....what do I need to enter after "Member" so that all the users in the collection are patched back to the SP List (separate line items).

Thank you in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @marney
You are doing good so far. you just need to patch your Person type column named Member. The code to patch a person column can be quite long.
Try this:
ForAll(collectUsers, Patch('WalkTheWorld Team Members', Defaults('WalkTheWorld Team Members'), { Title:wtwform_1.LastSubmit.Title, MID:wtwform_1.LastSubmit.ID, Member:{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Email, Email: Email, Picture: "", JobTitle: "", Department: "", DisplayName: "" } } ));

Was this reply helpful? Yes No
marney 77 on at

Like
a
(1)

Report
Copy link

Link copied!

Ah Adrian...a thousand blessings to you! Thank you very much indeed, works perfectly 🙂
Thanks again mate,
Marney

Was this reply helpful? Yes No

Join the conversation