I have a SharePoint list that has a people picker column (Foreman) and a form in PowerApps to create new records. The ComboBox for the People Picker is set up as follows:
Items: Office365Users.SearchUser({searchTerm: ForemanComboBox.SearchText})
DefaultSelectedItems: //DEFAULT FOREMAN IS LOOKED UP FROM ANOTHER LIST BASED ON ITEM ID ENTERED IN ANOTHER FIELD. ABLE TO MODIFY AS NEEDED//
First(
Office365Users.SearchUser(
{
searchTerm: LookUp(
LookupList,
ItemID = ItemID_DataCard.Update,
'Foreman'
)}))
Update: {
Claims: "i:0#.f|membership|" & Lower(ForemanComboBox.Selected.Mail),
DisplayName: ForemanComboBox.Selected.DisplayName,
Department: "",
Email: ForemanComboBox.Selected.Mail
}
When I click into the Update field, it is returning a record as expected that should be saved to SharePoint:
However, when I submit the form, the Foreman column in the SharePoint list remains blank. The curious thing is if I recall the SharePoint list back into the app through a gallery, it will display the Foreman information as I submitted it. If I pull the list into PowerBI, it's populated. If I export the SharePoint list to Excel the Foreman is populated. If I export to CSV, it is NOT populated.
WHAT IS HAPPENING THAT SOMETIMES THE PEOPLE PICKER IS POPULATED AND SOMETIMES IT IS NOT??????
Solved! Go to Solution.
No, I have not done anything with the SharePoint list, just created the columns. Creating a new view also did not make the name appear. Unfortunately I just think the column is bad for no explainable reason. I created a new people picker column and was able to get it to work with no issues. Thank you for the responses!
Hi,
Can you please try below formula in Update property of the people picker -
{
Claims: "i:0#.f|membership|" & Lower(ForemanComboBox.Selected.Mail),
DisplayName: ForemanComboBox.Selected.DisplayName,
Department: "",
Email: ForemanComboBox.Selected.Mail,
JobTitle: "",
Picture: ""
}
Thanks for the reply. Unfortunately, the result is the same. It still doesn't display the name in the SharePoint List.
Have you added any JSON code in column formatting ?
Create another sharepoint view and check if the value is visible
No, I have not done anything with the SharePoint list, just created the columns. Creating a new view also did not make the name appear. Unfortunately I just think the column is bad for no explainable reason. I created a new people picker column and was able to get it to work with no issues. Thank you for the responses!
User | Count |
---|---|
254 | |
106 | |
95 | |
50 | |
39 |