Hi @roncam ,
Where do you put your Checkbox control? Within a Gallery?
How do you patch value into your SP List when you check or uncheck the Checkbox? Using Patch formula?
I assume that you add the Checkbox control within a Gallery, and patch the value back to your SP list using Patch function, is it true?
Based on the needs that you mentioned, I have made a test on my side, plese take a try with the following workaround:
Set the OnCheck property of the Checkbox to following:
Patch('YourSPList', ThisItem, {Status: "Inactive"}) /* <-- Status column represents the column in your SP list to store the "Inactive" or "Active" value */
If the Status column is a Choice type column in your SP list, please modify above formula as below:
Patch(
'YourSPList',
ThisItem,
{
Status: {
Value: "Inactive"
}
}
)
Set the OnUncheck property of the Checkbox to following:
Patch('YourSPList', ThisItem, {Status: "Active"}) /* <-- Status column represents the column in your SP list to store the "Inactive" or "Active" value */
If the Status column is a Choice type column in your SP list, please modify above formula as below:
Patch(
'YourSPList',
ThisItem,
{
Status: {
Value: "Active"
}
}
)
Set the Default property of the Checkbox to following:
If(
ThisItem.Status = "Inactive",
true,
false
)
or
If(
ThisItem.Status.Value = "Inactive", /* <-- If the Status column is a Choice type column in your SP list */
true,
false
)
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
