Forms Creating a circular reference

(0) Share

Report

Posted on by Sajarac

3,295

Hi:

I have two forms that has to be completed both in order to get a product price like an Estimate based on some questions. But total price won't be completed until I have finished the forms. If I put a column in my SharePoint list i.e price. And in my form I made a reference to a label Price.txt then I am creating the circular reference so I can not Save the form.

To save bot forms I am using Submit(Form1); Submit(form2).

The questions is how can I submit both forms and additionally for Form1 add the price?

thanks in advance for any response

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@sajarac

If your total is coming only after form 2 is submitted and yet you have already submitted form1, then you will need to make another data operation in your form2 to update the record you make/updated in form1.

My suggestion would be...

Change your submit to be only: SubmitForm(Form1)

In Form1 in the OnSuccess Action, set the formula to:

Set(glbCurrentRecord, Self.LastSubmit); SubmitForm(Form2)

In Form2 in the OnSuccess Action, set the formula to:

UpdateIf(yourForm1DataSource, ID=glbCurrentRecord.ID, {TotalColumnName: <totalColumnValue>})

I hope this is helpful for you.
Sajarac 3,295 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Sir. Glad to see you around!
hope everything is good and thank you very much for your prompt response.
Unfortunately the value in this case the price is produced only with the combination of the two forms based on some inputs.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@sajarac

Good to see you as well. I think I have missed your last few posts and someone else grabbed them and responded.

I don't see that there is an issue.

The first form would submit (which you were doing before) and then you will be using (in the second) the combination of the first form and the second form to then put back a total value to the original record.

If that is not the case, then tell me more about the flow of your app and how that would not work.
Sajarac 3,295 on at

Like
a
(0)

Report
Copy link

Link copied!

OK, I need the combination of both forms to produce the price. but I am saving the back back to one of the Share Point List in this case (Form1).