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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,027)