Save variable of a form in excel

(1) Share

Report

Posted on by taubry

132

Hello,

I created a form with a TextInput in it allowing the user to enter money. Like this (to have 2 decimal) : https://powerusers.microsoft.com/t5/Building-Power-Apps/Input-box-automatically-have-two-decimal-places/td-p/656890

I took the exact same function as the agreed solution from this post.

It works fine, but when I do a SubmitForm(form1) everything gets saved in my excel document except the TextInput with the money input which is left blank.

Thanks in advance 🙂

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@taubry By default only the contents of DataCardValue fields are saved with the SubmitForm, and not the values of any possible random children controls you may have added into one or more Data Cards. - what out for this and check if it is the case for you. If it is make sure you are putting the value in DataCardValue of the Data Card - and not in some other custom control you added as a child of that Data Card.
taubry 132 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for your answer,
I understand the problem but I cannot find DatacardValue in my Datacard ...
I specify that it is a form of modification.
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@taubry Do you have screen shot of the Tree view with the Data Card expanded?

Are you able to select the Money input field? If so please select it and try provide a screenshot of both the canvas in Edit mode and the Left side of Tree View while the Money field is selected. Maybe it will help me to check it.
taubry 132 on at

Like
a
(1)

Report
Copy link

Link copied!

Voila :
DataCardValue15 is the Money input field.
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@taubry for DataCardValue15 what is the Default property set to right now?
You said you used something like the solution of post, if you did, check right now what is the OnChange property of it?
taubry 132 on at

Like
a
(0)

Report
Copy link

Link copied!
exactly like the post's solution,
in Default: var
in OnChange:
Set( var; Text( Round( Value(DataCardValue15.Text); 2 ); "[$-fr-FR]# ###,00" ) & "€" );; Reset(DataCardValue15)
taubry 132 on at

Like
a
(1)

Report
Copy link

Link copied!

Anyone know how to do it?
I tried to reset var in addition to form but without success...
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@taubry Montant HT_DataCard1
Check the Update property of this.
This is what is written back.
There may be some problem with it - you may need to change it for it to work correctly. For example, maybe you need to put the var directly there instead of what it says now. See if it works.

I bet it says something like DataCardValue15.Text in Update property of Montant HT_DataCard1, right?

Well of course it would be blank - the Text is blank!

So why is the Text blank? Because the solution you use requires Resetting the Control - which makes DataCardValue15.Text to be blank!

So then the solution would be:

Montant HT_DataCard1 Update Property - which now says something like DataCardValue15.Text

Either change it to var or DataCardValue15.Default - then I think it might work

Does it work?
taubry 132 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
it doesn't work with var in update, it always logs 0 ... and setting DataCardValue15.Default there is an error.
Thank you for your time on my problem.
taubry 132 on at

Like
a
(0)

Report
Copy link

Link copied!

Should I abandon the monetary format?