Hi @Anonymous ,
Do you want to update column value in a nested collection/table in your canvas app?
If you want to update column value in a nested collection/table in your canvas app using Update function or Patch function, I afraid that there is no way to achieve your needs in PowerApps currently.
The UpdateIf function or Patch function could only be applied to your original data source (e.g. a SP List, a SQL Table, a first level Collection, ...etc), it could not be used to update a column value inside nested collection.
As an alternative solution, you could consider find the specific record you want to update from your original data source (e.g. a SP List), and then update the specific record, then group your original data source again based on some columns. So please consider try the following formula (set the OnSelect property of a button to following😞
UpdateIf(
'Your Original Datasource',
Mont_f_id = Gallery5.Selected.Mont_f_id && ID = Gallery5.Selected.ID, // find record you want to update in your Orginal data source
{
Projekt_... : "Type Specific Value Here"
}
);
// Re-group your original data source based on several columns again
ClearCollect(
colMontWorkPlan,
GroupBy('Your Original Datasource', "TagName", "String...", "Kalenderw..", "GrpStrDat")
)
or
Patch(
'Your Original Datasource',
LookUp('Your Original Datasource', Mont_f_id = Gallery5.Selected.Mont_f_id && ID = Gallery5.Selected.ID), // Find the record you want to update in your orginal data source
{
Projekt_... : "Type Specific Value Here"
}
);
// Re-group your original data source based on several columns again
ClearCollect(
colMontWorkPlan,
GroupBy('Your Original Datasource', "TagName", "String...", "Kalenderw..", "GrpStrDat")
)
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
