@bcharpentier
There are some very specific reasons why you are seeing what you are. They are based on some problems you have in your formulas.
First - the use of SelectedText should be avoided because it is a deprecated property! You should be referring to your dropdown with Selected.Value (and the use of .Value is completely dependent on the Items property of your dropdown - so it might not be .Value!)
However, that is not where the issue you are seeing comes in. The problem is that your Submit button should ONLY have this formula in it: SubmitForm(EditForm2)
In your scenario, you are then navigating and collecting variables (for some reason). However, how do you know first that the form submitted properly? So you would be navigating away from the form even if it failed. This is not a good user experience!
Next, SubmitForm does not "wait". That means that SubmitForm kicks off asynchronously. So the rest of the formula may or may not happen after the submit is complete. Usually SubmitForm is quick, but you cannot rely on it.
This is why the Form offers an OnSuccess and OnFailure action. In those actions, you can place the formulas you want to occur in those respective situations.
Now - the real core of your issue, the Item property of the Form and the mode of the form is going to determine what is actually IN the form after it submits. So, if that does NOT provide the last submitted record, then your DataCard values will have all reset to the current record (not necessarily the last submitted record - again - depends on your Item and mode).
So, the suggestions are this:
1 - Change the Submit to: SubmitForm(EditForm2) only!
2 - In the OnSuccess action of your EditForm2, set the following formula:
Set(varCurrentRecord; Self.LastSubmit);;
Navigate(Accueil)
The variable varCurrentRecord will have every value from your form available to you. So, if you want the Machinerie value elsewhere in your app, then just refer to: varCurrentRecord.Machinerie
Same for others like the Date - Text(varCurrentRecord.Date; ShortDate)
In other words, there is no need to create so many variables for your data. It can all be in one and much easier to maintain and easier to type in!
I hope this is helpful for you.
