Power Apps

Answered

Remove Leading Zeros (from a scanned Barcode) in Power Apps Text Input

(0) Share

Report

Posted on by JAWL

393

Dear Experts,

How can I formulate the text input to remove leading zeros (not trailing zeros)?

Categories:

Building Power Apps

All responses (7)

Answers (2)

Sort by

rsaikrishna

3,703 on at

Like (1)

Report

Copy link

Link copied!

@JAWL

You can place label below the TextBox1 control and set its Text property with following formula:

Value(TextBox1.Text)

You can place same formula in the Textbox also.

I hope this will help you.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

@rsaikrishna
My Default formula for the DataCardValue is Value(varScanTO):

No issue if I use the Barcode Scanner button in Power Apps:

But it still shows leading zeros if I use the external scanner:

I have also tried below formula but nothing works:

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@JAWL

Please try below workaround:

Place another textbox or label "TextBox2" on the screen along with your existing Textbox.

TextBox2.Text = Value(TextBox1.Text)

Please check if you are getting appropriate number with external scanner. If you do, then hide the first textbox control.

Please give a try and let me know if that works or not.

Regards

Krishna Rachakonda

JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

@rsaikrishna I guess it should work but when I click Submit Form button, it will take DataCardValue instead of the text input right? Or I should use patch function to submit the textbox input instead?

Why can't I just modify formula in the DataCardValue directly?

Must create additional Text Input/Label to remove leading zeros?
Verified answer

rsaikrishna 3,703 on at

Like
a
(0)

Report
Copy link

Link copied!

@JAWL

In the data card's Update property, mention Label1.Text value.

When you submit the form, it will submit the value from the Label1.Text.

Regards

Krishna Rachakonda
JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

@rsaikrishna
There is an error:
Verified answer

JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rsaikrishna thanks for your meeting invite to resolve this error! Big thanks!

So the solution that you have showed me is to use the formula for DataCard Update property as per below. Default property can maintain as ThisItem.Title.