Answered

Patch a Person to single Sharepoint row

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everbody,

today I have a question for you regarding the Patch-function. I want to add a person (Office365 Account) to an single row.

The table contains an ID and the person.

Patch(SeatPlanReservation; First(Filter(ReservationPlan;Titel="0101")); { Reservation: Office365-User.MyProfile() })

But the last entry wont work. (Office365-User.MyProfile()) I allready tried to get my User (Person) with .UserProfile(User().Email)!

The error message said, that the record wouldn't work, because PowerApps or the Sharepoint List is using an other value.

I never worked with records, any ideas? I just want to put the Office365-Account to the list. The user will always be the logged user of the using powerapp.

Best regards and thank you

DA4

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Pstork1 69,651 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Take a look at the solution in the following thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Saving-data-from-powerapps-to-SP-lists-person-Group-column/td-p/77329

To patch a person object to SharePoint you have to supply the values in a particular format. You can get the values you need from the profile object, but you can't save it directly.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

It's not supported to use "Office365-User.MyProfile()" directly to update person field.

Here are two ways to update person field:

1)use combo box

set the combo box's Items:

Choices(SeatPlanReservation.Reservation)

choose your account in the combo box.

Then try this fomula:

Patch(SeatPlanReservation; First(Filter(ReservationPlan;Titel="0101")); { Reservation: combo box1.Selected })

2)use formula to update

Try this:

Patch(SeatPlanReservation; First(Filter(ReservationPlan;Titel="0101")); { Reservation: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|"& User().Email, Department:"", DisplayName:User().FullName, Email:User().Email, JobTitle:"", Picture:"" } } )

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help! Works excellent! 👍

Was this reply helpful? Yes No