@Anonymous
I just want to be clear of the steps.
-You have a text box on the Form already
-That must be a Column that is part of your submit?
-And once the form is submitted, and the data comes back... is there data in that column or are you using other columns to calculate?
I believe you should use a calculated Column instead, but here is how you do what you asked.
1. In your button do your Submit
2. The next line, would be you reading the Values that came back and doing your calculation
3. Do a Patch to that column (not another Submit). Like this
Where TestList put your list/table name, Form1.LastSubmit, points to the record you just submitted, so you can patch it, and the Title is just me using my own column, but thats where you would put your Column and its Calulated Value
Patch(TestList, Form1.LastSubmit,
{
Title: "MyCalculated value"
}
)
Question: Have you thought about using a Calculated Column in the List or Table?
The issue I see is you want the front end to do a calculation, but then immediately, submit again, which you can do, it will trigger another Submit and how I would normally tell you to solve this wont work, as it will cause a loop.
Doing multi submits like this can really mess up the standard usage of OnSuccess and OnError
If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
