Hi,
I have an edit form in my powerapp that i am using a sharepoint list as the data source. When i hit submit on the form some of the columns inputs are not showing up on the sharepoint list. EX i have a combo box that is using Office365Users datasource, and i have a column in my sharepoint list call submitter the data type is people or group in the SP list, yet it does not pouplate the info. Is there a way to troubleshoot this?
Solved! Go to Solution.
Hi @patty789 ,
Do you want to submit office 365 users to Person column of SP list?
What is the item property of the combo box? What is the Update property of Person column datacard?
In order to get that, you have to patch a record which contains "Claims","Department","DisplayName","Email","JobTitle","Picture" columns. Although not all values are required, you need to list them all.
Please put following formulas to Update property of Person column DataCard.
{
Claims:"i:0#.f|membership|" & ComboBox1.Selected.UserPrincipalName, Department:"", DisplayName: ComboBox1.Selected.DisplayName, Email: ComboBox1.Selected.UserPrincipalName, JobTitle:"", Picture:""
}
Hope this can help.
Best regards,
Sik
Hi @patty789 ,
Do you want to submit office 365 users to Person column of SP list?
What is the item property of the combo box? What is the Update property of Person column datacard?
In order to get that, you have to patch a record which contains "Claims","Department","DisplayName","Email","JobTitle","Picture" columns. Although not all values are required, you need to list them all.
Please put following formulas to Update property of Person column DataCard.
{
Claims:"i:0#.f|membership|" & ComboBox1.Selected.UserPrincipalName, Department:"", DisplayName: ComboBox1.Selected.DisplayName, Email: ComboBox1.Selected.UserPrincipalName, JobTitle:"", Picture:""
}
Hope this can help.
Best regards,
Sik
@v-siky-msft Thank you so much for your help. I added the formula to the update property of the Person data card and it worked.
User | Count |
---|---|
257 | |
110 | |
90 | |
51 | |
44 |