Dropdown selected Value

[bcharpentier]

Hi Everyone,

I have a problem today with value in editform.

I want to save some value from edit form to global variables.

 

In card of the editform I use dropdownxxx.SelectText.value to update the record, and this is working fine. 

But when I try to use the same expression (dropdownxxx.SelectText.value) out of the card, the value is empty.

I don't understand why, you can see in the first attached picture the value is empty, but when I do it in the update value of the card, I have the good value (see second attached picture).

Can anyone knows why ?

Thank's for reply.

[RandyHayes]

@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.

[bcharpentier]

@RandyHayes  Many thank's for all your explications. 

Feedback to tell you it works fine, and all of your explication will help me to ameliorate my App.

Thank's 🙂