Hi @Rob_G ,
Do you want to update the Calculated field from your SP List in your canvas app?
Firstly, if you want to update the Calculated field from your SP List in your canvas app, I afraid that there is no way to achieve your needs.
The Calculated field from your SP List would be recognized as a 'Read-Only' type field, which could not be updated in canvas app. So you could not update the Calculated field from your SP List in your canvas app using Patch function or SubmitForm function.
If the 'Calculated field' in your SP List is based on other columns in same list, you could consider update the related columns in your canvas app, then the 'Calculated field' would be re-calculated automatically in your SP List.
If you want to update your SP List multiple records via pressing a button once time, rather than one by one, I think the ForAll function and Patch function could achieve your needs. You could consider add a Gallery in your app, connect it to your SP List. Then configure your Gallery as a Editable GRID, add some Text Input box inside your Gallery, set the Default property of the Text Input box to following:
ThisItem.Field1
ThisItem.Field2
...
add a "Submit" button outside your Gallery, set the OnSelect property to following:
ForAll(
RenameColumns(Gallery1.AllItems, "ID", "ID1"),
Patch(
'Your SP List',
LookUp('Your SP List', ID = ID1),
{
Field: TextInput1.Text,
Field2: TextInput2.Text,
...
}
)
)
you could made changes to the related fields directly through the Text Input box control, then press the "Submit" button, then all changes you made in your Gallery would be updated back to your SP List.
More details about configuring a Gallery as a Editable GRID, please check the following video resource:https://www.youtube.com/watch?v=gRAnpZJESiE
https://www.youtube.com/watch?v=O2WqhRTUhyw
Please try above solution, hope it helps your scenario.
Best regards,
