web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Patch Email into peopl...

Power Apps

Answered

Patch Email into people column in sharepoint

(0) Share

Report

Report

Posted on by Appleonwindows

133

Hi, I am trying to patch user().email into people column in sharepoint as follows

Column in Sharepoint

Patch(
 'Table1',
 {ID: Self.LastSubmit.ID},
 {PersonWhoSubmit:User().Email}
)

However, the following error occurs

The type of this argument 'PersonWhoSubmit' does not match the expected type 'Record'. 
Found type •Error'.

May I know how should I amend my formula above? I tried Text and value but it doesnt work

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

v-mingkz-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Appleonwindows,
The person type column expects a record like following expression.
Patch( 'Project Tasks', LookUp('Project Tasks', ID=1), { EmployeePerson: { Claims: "i:0#.f|membership|mdevaney@companyname.com", Department: "", DisplayName: "Matthew Devaney", Email: "mdevaney@companyname.com", JobTitle: "", Picture: "" } } )

Best Regards,
Kyrie

Was this reply helpful? Yes No
Appleonwindows 133 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for the prompt reply.

May I know how do i obtain the claims from user()? As i need all of the item to be formularize (dynamic approach)

When I got to User(), it only prompt me Email, FullName, and Image

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Appleonwindows
Claims: "i:0#.f|membership|" & User().Email,

Was this reply helpful? Yes No

Join the conversation