Answered

Update a value in a nested collection

Like (0) Share

Report

Posted on 1 Jul 2020 20:54:01 by Community Power Pla...

Hi to all,

I am trying to update a specific value in a nested collection, 2nd level. The collection has been created by grouping a table. The lines in the inner collections have IDs, so I can easily identify the ID to update.

Can anyone provide the syntax?

I tried both UpdateIf and Patch statement, without success...

For example:

UpdateIf(outercollection;innercollection.mont_f_id = gallery5.selected.mont_f_id;{innercollection:

PowerApps is just proposing for the curly brackets statement this one statement: {innercollction:

I tried a patch statement and am desparate now...anyone with a solution??

Thank you and best regards

TheSwissPowerAppsEnthusiast

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

Community Power Pla... on 02 Jul 2020 at 07:59:26

Like (0)

Report

Re: Update a value in a nested collection

Hi community team,

I am doing it exactly how you proposed it. The disadvantage is, that the gallery where I am using the nested collection is losing the "selected" information. But I can live with it or find a different solution by saving the selected one to different collection.

Thank you for your fast response. Conclusion is, I am not too stupid for it, but it is not working.

Regards

Bernd

The Swiss PowerApps Enthusiast
Verified answer

v-xida-msft on 02 Jul 2020 at 02:53:54

Like (1)

Report
Re: Update a value in a nested collection

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,