[Patch Nested Galleries]

[Harry_G]

I have to save nested Galleries Values in SharePoint, I'm Very Confuse to Patch the nested Galleries Values My schema is look like this.

Collect(PriceBook,
{Type:"1",
Product:"",
btnSave:true,PriceBookServices:{Type:"1",'Billing Code':"1",'Billing Code Name':"",Price:"",Product:"",'Service Type':"1",Service:"1",Unit:"1",MonthRange:"",Description:"",Discount:0,SaveButton:true,BusinessJustificaton:""}});

This is my collection. The scenario is I have to select Product and sub product than Gallery2 rows is auto populate with filter values. I have facing issue to patch them all. Any help would be appreciated.

Thanks,

Harry_G

[VijayTailor · Accepted solution]

Hi @Harry_G ,

You can Patch all the records using the ForAll Function.

Like below - 

ForAll(CollectionName,if Need To create new Record then use default(sourceName),SourceName,{Values here});

Thanks,
Vijay

[Harry_G]

@VijayTailor 

Thanks for giving me the clue. In my scenario on save of parent gallery row this formula works.

ForAll(ParentCol,Patch(ChildCol,Defaults(ChildCol),{Item:Value,........}));

Btw thanks again.

Thanks,

Harry_G