Patch(
'Work Requests',
Defaults('Work Requests'),
{Title:Value(TextInput2.Text),
Client:TextInput2_1.Text,
Staff:ComboBox1.Selected.Mail})
not able to submit the data
How to Patch all the information
I need to submit all the information but only staff and senior information not able submit ,Staff and senior information taking from 0ffice 365
Solved! Go to Solution.
Hi@RajSaha_,
Based on the issue that you mentioned, do you want to patch user information from the Office365Users to SP list?
Could you please tell me
I want to tell you that if you have connected Office365Users to your App and want to patch it back to the Person/Group column within your SP list, you should obey the following format:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|qi@wiXXXX.onmicrosoft.com",
Department:"",
DisplayName:"Qi Qiao",
Email:"qi@wiXXXX.onmicrosoft.com",
JobTitle:"",
Picture:""
}
In my scenario, I have a Person column named "Staff" and the Items property of the Combo Box is set to:
Choices([@'Work Requests'].Staff)
In your scenario, I assume that you have the Person/Group column within your SP list, and please modify the formula as below:
Patch(
'Work Requests',
Defaults('Work Requests'),
{
Staff: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
DisplayName: DataCardValue6.Selected.DisplayName,
Claims: DataCardValue6.Selected.Claims,
Department: "",
Email: DataCardValue6.Selected.Email,
JobTitle: DataCardValue6.Selected.JobTitle,
Picture: ""
}
}
)
Please check to see if this could help you.
Regards,
Qi
@RajSaha_
Are you trying to PATCH a SharePoint Person column? Here's an example of how to do it:
https://matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch...
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi@RajSaha_,
Based on the issue that you mentioned, do you want to patch user information from the Office365Users to SP list?
Could you please tell me
I want to tell you that if you have connected Office365Users to your App and want to patch it back to the Person/Group column within your SP list, you should obey the following format:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|qi@wiXXXX.onmicrosoft.com",
Department:"",
DisplayName:"Qi Qiao",
Email:"qi@wiXXXX.onmicrosoft.com",
JobTitle:"",
Picture:""
}
In my scenario, I have a Person column named "Staff" and the Items property of the Combo Box is set to:
Choices([@'Work Requests'].Staff)
In your scenario, I assume that you have the Person/Group column within your SP list, and please modify the formula as below:
Patch(
'Work Requests',
Defaults('Work Requests'),
{
Staff: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
DisplayName: DataCardValue6.Selected.DisplayName,
Claims: DataCardValue6.Selected.Claims,
Department: "",
Email: DataCardValue6.Selected.Email,
JobTitle: DataCardValue6.Selected.JobTitle,
Picture: ""
}
}
)
Please check to see if this could help you.
Regards,
Qi
User | Count |
---|---|
195 | |
123 | |
86 | |
48 | |
41 |
User | Count |
---|---|
281 | |
163 | |
138 | |
80 | |
76 |