Number is rounded up and down by Power Apps

(0) Share

Report

Posted on by Peter1991

Hi, in my code an ID from Power Apps is automatically rounded down. For example,

from

093220000000010136923922010111

93220000000010140000000000000

It's not due to the Excel formatting.

Below is the code to write the ID into an Excel table. Can someone help me identify where I made a mistake?

Patch(
Tabelle2;
Defaults(Tabelle2);
{
'ID': Text(Value(First(Split(Eingabe.Text; "|")).Value));

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

MaximusDecimus 281 on at

Like (1)

Report
Hey @Peter1991 ,

I believe that your Value() function is the cause for this issue - tried the same input on my end and I was able to replicate the issue. Value() is converting your text into int which removes your leading 0 and rounds the value.

Hopefully you can amend the first line of your patch to the below and that should resolve your issue.
'ID': Text(First(Split(Eingabe.Text; "|")).Value);

Was this reply helpful? Yes No
Peter1991 38 on at

Like (0)

Report

Perfect, that has already helped me, the number is now being transferred correctly.
However, I am still seeing the notification "Fehler bei Übertragung".
The "if" function is supposed to check whether the record was transferred correctly to Table 2, but it is not recognizing it.
Do you happen to know the solution?

Was this reply helpful? Yes No
Verified answer

MaximusDecimus 281 on at

Like (1)

Report
I think you could replace most of the if() by first having your patch statement in a Set(), so something like this:

Set(varNewRecord; Patch( Tabelle2; Defaults(Tabelle2); { 'ID': Text(Value(First(Split(Eingabe.Text; "|")).Value)); Anrede: Last(FirstN(Split(Eingabe.Text; "|"); 2)).Value; Titel: Last(FirstN(Split(Eingabe.Text; "|"); 3)).Value; Firma: Last(FirstN(Split(Eingabe.Text; "|"); 4)).Value; Vorname: Last(FirstN(Split(Eingabe.Text; "|"); 5)).Value; Nachname: Last(FirstN(Split(Eingabe.Text; "|"); 6)).Value; Name_zusatz: Last(FirstN(Split(Eingabe.Text; "|"); 7)).Value; STR_: Last(FirstN(Split(Eingabe.Text; "|"); 8)).Value; HNR: Last(FirstN(Split(Eingabe.Text; "|"); 9)).Value; PLZ: Last(FirstN(Split(Eingabe.Text; "|"); 10)).Value; Ort: Last(FirstN(Split(Eingabe.Text; "|"); 11)).Value; 'Redress-Bemerkung': Dropdown1.Selected.Value } ));;

then replace
CountRows(Filter(Tabelle2; 'Sendungs-ID' = """" & Value(First(Split(Eingabe.Text; "|")).Value))) > 0;
with
!IsBlank(varNewRecord.ID);
making sure to set varNewRecord to blank after the if statement:
Set(varNewRecord, Blank());

Was this reply helpful? Yes No