Patch - Create new record username and email of current logged in

[_sourcecod3_]

Hi all,

How can I add username and email address of the current user logged in to a SharePoint list the Patch() function? This is what I have so far: 

Patch(dataSource, Defaults(dataSource),{Employee: {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",Claims:"i:0#.f|membership|" & Lower(User().Email), Department:"",  DisplayName:User().FullName,  Email:User().Email,  JobTitle:".",  Picture:"."}})

 Any help is appreciated

Thanks

[v-monli-msft]

Hi @_sourcecod3_ ,

First of all, your formula only contains one Employee field, is it the only Required field in your SharePoint list? You have to include all the Required fields in Patch. 

Secondly, please change the field formula to:

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & Lower(User().Email),
Department:"",
DisplayName:User().FullName,
Email:User().Email,
JobTitle:"",
Picture:""
}

Regards,

Mona

[_sourcecod3_]

@v-monli-msftso that's what I'm confused with, how do I add the email address and update the column in the SharePoint list?

Thanks