Hi @Anonymous ,
Could you please share a bit more about your scenario?
Do you want to change the Completado column to 1 if the Checkbox is selected when you submit your form data?
Based on the operation that you done within your Edit form, I think there is something wrong with it. I have made a test on my side, please take a try with the following workaround:
Within the Edit form of your app, set the Update property of the Completado Data card (Compledato_DataCard1) to following:
If(
DataCardValue3.Value = true, /* <-- DataCardValue3 represents the Checkbox control in your Edit form */
1,
0
)
Set the Default property of the DataCardValue3 (your Checkbox control) to following:
If(
ThisItem.Completado = 1,
true,
false
)
then when you submit your form data (using SubmitForm() function), the corresponding Completado column in your Excel table would be updated.
In addition, if you want to directly update the correspoding Completado column in your Excel table when you check/Uncheck the Checkbox rather than use SubmitForm function, I think the Patch function could achieve your needs.
I have made a test on my side, please take a try with the following workaround:
Set the OnSelect property of the Checkbox (DataCardValue3) to following formula:
If(
DataCardValue3.Value = true,
Patch(
'YourExcelTable',
BrowseGallery.Selected,
{
Completado: 1
}
),
Patch(
'YourExcelTable',
BrowseGallery.Selected,
{
Completado: 0
}
)
)
Set the Default property of the DataCardValue3 (your Checkbox control) to following:
If(
ThisItem.Completado = 1,
true,
false
)
More details about Patch function in PowerApps, please check the following article:
Patch function
Best regards,
