Save button - collections update/refresh

Like (0) Share

Report

Posted on 6 Sep 2021 05:16:24 by rbalza

235

Hi everyone, I am having a hard time figuring this one out. So I have a save button that saves the collection onto my SP lists. I have another button that generates the collection - new row button. As you can see on the client total (bottom) was incorrect as the collections update only when I hit the new row button. How can I refresh the collections before saving them to my sp list in order to have the right amount? Thanks in advance.

Here's new row button code

Collect(
 GalleryPricingData,
 {
 Job_x0020_Category: JobCategory.Selected.Result,
 Entity_x0020_Type: EntityType.Selected.Result,
 Job_x0020_Type: JobType.Selected.Result,
 Invoice_x0020_Description: InvoiceDescription.Value,
 Min_x0020_Fee: MinFee.Value,
 Qty: Quantity.Value,
 Nominal_x0020_Value: NominalValue.Value,
 Complexity_x0020_Value: ComplexityValue.Value,
 Total: Total.Value,
 Client_x0020_Name: ClientName.Selected.Result,
 ClientGroup: ClientGroup.Value,
 ClientCode: ClientCode.Value
 }
)

Save button code

 Collect(
 'Saved Data-18162676-8464-4e9f-ae16-3c8b172e614d',
 GalleryPricingData
 );
 Clear(GalleryPricingData);
 Reset(ClientName);
 Reset(ClientGroup);
 Reset(ClientCode);
 Notify(
 "Record has been succesfully saved",
 Success,
 2000
 );

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft on 10 Sep 2021 at 01:53:52

Like (1)

Report

Re: Save button - collections update/refresh

Hi @rbalza :

This thread seem the same like this one:

Solved: Re: Saving updated gallery (collections) / Auto-re... - Page 3 - Power Platform Community (microsoft.com)

If this problem is resolved,please consider marking this reply as a 'solution' to help others.

If you still have any questions, please let me know.

Best Regards,
Bof
Community Power Pla... on 06 Sep 2021 at 15:01:12

Like (1)

Report

Re: Save button - collections update/refresh

Hello @rbalza
you can use the below steps to overcome your issue

1) Apply the same Patch/Update to the collection that you are applying to the data source.
2) Re-run whatever code you ran to create the collection, to begin with. Make sure to use a Clear() or ClearCollect as the first statement or you'll get duplicates.

Thank You
WarrenBelz 147,116 Most Valuable Professional on 06 Sep 2021 at 06:31:38

Like (0)

Report

Re: Save button - collections update/refresh

Hi @rbalza ,

You have not included the formula on the total control