cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abd3127
Kudo Kingpin
Kudo Kingpin

Saving data from powerapps to SP lists person/Group column

Hello ,

i need to save the user info in Person/Groups column of my SP list.

I am selecting the data from a Drop down list.

When i do "DD.selected.value' it gives mee error saying that it needs a record to save.

How can i do this??

23 REPLIES 23

@v-micsh-msft , I'm trying to patch a multi-select person field in a list using a collection which contains a column that is a single-select person field.

 

So, the collection contains the columns:

["Title"(text),"Username"(single-select person field),<some other columns that don't matter>]

 

The items in the collection are from a "Mentors" list and I have a "Requests" list. The idea is that a request will be sent to one or more mentors, and in the Requests list there is a multi-select person field (SentTo) to record to whom the request was sent.

 

I'm sure this is possible, but can't figure out the syntax. I've tried variations of Table, Concat and ForAll, but PowerApps is not having any of them. Any help would be greatly appreciated.

Anonymous
Not applicable

Hi,

I am new to the use of SP List as data connector to my Papp. I do a Patch formula pasted below. There is an issue with passing an attribute which is text into SP list to variable that is type Person/Group i.e. RequestedBy. From some research, I have learned about the section after RequestedBy in the formula below but have such little knowledge do not know if going in the right direction. Any suggestion greatly appreciated. RequestedByAutoInput is the Papps variable which basically captures the User().Fullname value. Lastly, all other information is passed okay to the SP List since all these variable are identified as Single Line text in SP.

 

Patch(

    CertRegistrationProcess, Defaults(CertRegistrationProcess),

    {CertReqID: CertReqID.Text,

RequestedBy: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpanderUser",
Claims:" “,
Department:" ",
DisplayName: RequestedByAutoInput.Text
Email: “ ”,
JobTitle:" ",
Picture:" "},

        RequestorEmail: RequestorEmailAutoInput.Text,

        RegistrationDate: RegistrationDateAutoInput.Text,

        CertTypeID: CertTypeID.Text,

        CertName: CertName.Text,

        CertCompany: CertCompany.Text,

        CertCompanyID: CertCompanyID.Text,

        ExamRequestDate: ExamRequestDate.SelectedDate,

        ExamRequestTime: ExamRequestTime.Selected.Value,

        CertDateComplete: CertDateComplete.SelectedDate,

        RequesterComments: RequesterComments.Text,

        Office365UserID: Office365UserID.Text

    }

)

 

Thanks.

This is static information, what will be the solution for Dynamic data from the combo box for Multi Value person column?

Hi Brendan,

 

Although its been some time since you asked the question, I believe your Patch function is malformed. Consider this Patch function:

 

Matthew_Harding_1-1615376162175.png

 

Note how i'm using a LookUp function to identify the record to update, then an object literal for the update payload afterwards. This syntax works fine for me as tested today.

 

Of course I hard coded the ID but this could be passed in from a Gallery or variable equally.

 

I hope this helps you or others with the same issue.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,138)