I'm clicking on a button from within a gallery to patch the name of the current user into a SharePoint list. The formula I'm using is listed at the bottom of this submission.
Everything works perfectly fine until I add the "Name" column. Then, it does not give me an indicator of a formula error but fails on click.
I checked the Name setting in the field in my SharePoint list and found the following:
It is a Person or Group field.
It is not required.
It does not have unique values
It does not allow multiple selections
Allows people only selection
Can choose from all users
Also, I added a label to see what varCurrentUser shows and it has my email and full name as the current user. The full name as displayed in the label shows in exactly the format I'd expect to see in my list.
If I use varCurrentUser.Email at the end of the Claims line, this is the message I get:
"The requested operation is invalid. Server response: ERG registration failed. The specified user _scrubbedSensitiveData_could not be found."
If I use varCurrentUser.FullName at the end of the Claims line, this is the message I get: "The requested operation is invalid. Server response: ERG registration failed. The specified user i.0#.f|membership|Zalme, Cindy could not be found."
Here is my formula:
Patch('ERG Registration', Defaults('ERG Registration'),
{Title:varCurrentUser.FullName,
EmployeeNumberorEmail:varCurrentUser.Email,
EventID:ThisItem.ID,
EventName:ThisItem.Title,
EventSubHeadline:ThisItem.OneLineSubHeadline,
Name:{
Claims: Concatenate("i.0#.f|membership|",varCurrentUser.FullName),
Department:"",
DisplayName:varCurrentUser.FullName,
Email:varCurrentUser.Email,
JobTitle:"",
Picture:""}
})
Does anyone have any insight to this. I've exhausted all I know to do.
Thank you.
