Hi Community.!!
I have one SharePoint where the field Status is a Choice Option (with the options Rejected, Pending, Approved).
On the other hand, I am developing an app where the user can use the checkbox to upate the records.
I was working in the formula but was impossible to me.
Please. Could you help me?
thank you.!!
Solved! Go to Solution.
@Anonymous
You will need to change your formula to the following to Patch a Choice column in SharePoint:
Patch('DocuSign User Access Review',
LookUp('DocuSign User Access Review', ID=ThisItem.ID),
{Status:
{Value: "Pending",
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}
}
)
)
Notice also that you should consider using a lookup rather than a First(Filter statement. The performance is better and both give you the same result.
Also consider that if your Gallery items are based on the datasource you have, you can shorten to this:
Patch('DocuSign User Access Review',
ThisItem,
{Status:
{Value: "Pending",
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}
}
)
)
I hope this is helpful for you.
@Anonymous
You will need to change your formula to the following to Patch a Choice column in SharePoint:
Patch('DocuSign User Access Review',
LookUp('DocuSign User Access Review', ID=ThisItem.ID),
{Status:
{Value: "Pending",
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}
}
)
)
Notice also that you should consider using a lookup rather than a First(Filter statement. The performance is better and both give you the same result.
Also consider that if your Gallery items are based on the datasource you have, you can shorten to this:
Patch('DocuSign User Access Review',
ThisItem,
{Status:
{Value: "Pending",
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}
}
)
)
I hope this is helpful for you.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
181 | |
52 | |
41 | |
38 | |
33 |
User | Count |
---|---|
245 | |
80 | |
71 | |
69 | |
66 |