You’re offline. This is a read only version of the page.
40
I have two choice columns in Sharepoint. I want to patch the update status from Powerapps everything is fine there is no error. Only one column can path to SharePoint but another no-show.
and this is my code
Share
ReportForAll(
collectBatchSAP,
Patch(
User_Request_Form,
Defaults(User_Request_Form),
{
Name: FirstName & " " & LastName,
Department: Department,
Role: Position,
Computer_Name: Computer_Name,
Username_ALL: SAP_UserName,
EmployeeID: Employee_ID,
'Requested ID': User().FullName,
Status: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: 1,
Value: "Activated",
People_Stat: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: 1,
Value: "Register"
}}}
)
)The choice column in SharePoint are Status and People_Stat
Please help me thank you in advance.
Hi @saranp780 ,
A slight refactor of the code you provided might be the solution:
All responses (
Answers (
ForAll(
collectBatchSAP,
Patch(
User_Request_Form,
Defaults(User_Request_Form),
{
Name: FirstName & " " & LastName,
Department: Department,
Role: Position,
Computer_Name: Computer_Name,
Username_ALL: SAP_UserName,
EmployeeID: Employee_ID,
'Requested ID': User().FullName,
Status: {Value: "Activated"},
People_Stat: {Value: "Register"}
}
)
)
Hope this helps!
Aaron
