Updating SharePoint List item with Email

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to create new items in SharePoint List.

One of the columns in the SharePoint list is Contact Person. This field type in SharePoint is "Person or Group".

I'm trying to update the list using the following code:

Patch('Register',Defaults('Register'),
{'Communication Purpose': CommPurposeTxt.Text},
{'Communication Date':CommDate.SelectedDate},
{'Contact':ApplicantEmailLbl.Text},
)

ApplicantEmailLbl is a label with the value User().Email

The error message is attachedError Message

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@Anonymous

You cannot patch a Person column by just supplying the email address, you need to provide a full person record to it.

Consider this to replace your Formula:

Patch('Register', Defaults('Register'), {'Communication Purpose': CommPurposeTxt.Text, 'Communication Date':CommDate.SelectedDate, 'Contact': { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(ApplicantEmailLbl.Text), Department:"", DisplayName:ApplicantEmailLbl.Text, Email:ApplicantEmailLbl.Text, JobTitle:".", Picture:"." } } )

Also note (to save you time) you do not need to put { } around each column of your record, just to start and end as above.

I hope this is helpful for you.

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

Like (0)

Report
Copy link

Link copied!
Thanks @RandyHayes
That was spot on. I just have one question:
Would any of these values be updated in Active Directory?

Department:"", DisplayName:ApplicantEmailLbl.Text, Email:ApplicantEmailLbl.Text, JobTitle:".", Picture:"." }

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

No, the user object in SharePoint is not Active Directory. SharePoint has always had its own user and group information, and the records for that are stored in that format in SharePoint.

SharePoint, however will derive that "empty" values it needs from ActiveDirectory (if the user is "new" to SharePoint) and from their User object in SharePoint (if they have already access SharePoint before).

In order to "trigger" SharePoint to "fill in the blanks", you have to supply at least the Claims, DisplayName and Email with values and the rest can be "dummy" values.

Was this reply helpful? Yes No