I have a SP list, "On-Call Switch Request-BETA" and one of the fields is a person choice field that I would select someone from the office 365 directory to put in this field. In power apps, this field shows up as a Choices field. When I submit a form, I get all of the details, however my record of the person I picked in the powerapp doesn't stay there in the SP list entry.
Hi,
did you set the sharepoint column to type "person"?
If you are using Office 365 as the user record source of the Combobox, then you will need to convert to a SharePoint user record in your Update property of the datacard.
User records in 365 are different than in SharePoint and you cannot use a 365 record for SharePoint.
Your Update Property should be something similar to the following:
{
Claims:"i:0#.f|membership|" & Lower(yourCombobox.Selected.Email),
Department:"",
DisplayName: yourCombobox.Selected.FullName,
Email: yourCombobox.Selected.Email,
JobTitle: "",
Picture: ""
}
I hope this is helpful for you.
I have tried your formula based on the screenshot below. Something is still off.
What is the error? Please hover over the red x or view the formula with the error and click in the formula to get the error.
I was using "DataCard356.Selected.Email" instead of "DataCardValue356.Selected.Email" and that part now works, there is no error. However, it is still blank in my SP list record.
This is my formula...
{ Claims:"i:0#.f|membership|" & Lower(DataCardValue356.Selected.Email),
Department:"",
DisplayName: DataCardValue356.Selected.DisplayName,
Email: DataCardValue356.Selected.Email,
JobTitle: "",
Picture: ""
}
Formula looks good.
What is the Formula on the Items property of DataCardValue356 ?
Choices([@'On Call Switch Request-BETA'].approvingEmployee)
Ah, so then you are NOT using the Office 365 directory as you first stated. You are actually using SharePoint users already. In that case, your update property should just be : DataCardValue356.Selected
User | Count |
---|---|
252 | |
102 | |
94 | |
50 | |
37 |