How to do math inside patch function

(0) Share

Report

Posted on by 9kMan

Hi.

I'm trying to get this to work:

SubmitForm(Form1);; Patch( '[dbo].[Grupper]'; LookUp('[dbo].[Grupper]'; kar_id = varKarId); { antall: Value(DataCardValue7.Text) - Value(DataCardValue3.Text) });; NewForm(Form1)

, but it seems the math part

Value(DataCardValue7.Text) - Value(DataCardValue3.Text

doesn't work inside the patch function. I've gotten it to work in a label, though.

Do I have to do the math in a hidden label and refer to that label inside the patch function or is an easier way possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

9kMan 81 on at

Like (0)

Report
Copy link

Link copied!

I figured it out. I had to submit the form AFTER the patch statement. Silly mistake.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@9kMan

First, you should move the Patch to the OnSuccess action of your EditForm. As you have your formula now, if the initial submit fails, your Patch would still happen. If you move this formula to the OnSuccess, then you will be assured that the initial submit was a success and then your patch can proceed.

Also, it is not good to refer to the DataCard controls after you submit. Instead you would want to refer to the submitted values. This is found in the LastSubmit property of your form. So, without knowing what your DataCardValue7 or DataCardValue3 are based on (i.e. the column name in your datasource), then your formula in your OnSuccess would be the following:

Patch('[dbo].[Grupper]'; LookUp('[dbo].[Grupper]'; kar_id = varKarId); { antall: Form1.LastSubmit.antall - Form1.LastSubmit.otherColumn } );; NewForm(Form1)

Also, if kar_id is something that is actually submitted in some way through your form, then you can replace the entire formula with the following:

UpdateIf('[dbo].[Grupper]'; kar_id = Form1.LastSubmit.karID; //or whatever it is called { antall: Form1.LastSubmit.antall - Form1.LastSubmit.otherColumn } );; NewForm(Form1)

This just saves the cost of doing a LookUp on the record and is a bit more faster.

I hope this is helpful for you.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@9kMan

Please read my response - with your current method of Patching first, you risk a record patch that might not be reflective of your scenario if there is a submit failure.

Was this reply helpful? Yes No
9kMan 81 on at

Like (1)

Report
Copy link

Link copied!

Thanks! I didn't know about the LastSubmit function. Didn't think of using the OnSuccess action either.

Was this reply helpful? Yes No