web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Converting to a numeri...

Power Apps - Building Power Apps

Answered

Converting to a numeric format failure

(0) Share

Report

Report

Posted on by Andrea2000

36

Hello there!

I have a drop down menu, with this items 0, 0,5, 1, 1,5, 2...

When the form is sent to excel the numbers are sent in a text format not in a numeric format.

This happen only with decimal numbers.

Example: 2 is sent correctly, 2,5 is sent in a text format and i can't find a way to convert the values.

Thank you in advance for your help!

Categories:

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Mitanshu 1,644 Moderator on at

Like (1)

Report
Re: Converting to a numeric format failure

It seems the language locale setting is different between Power App and Excel.

Outside continental Europe, the decimal numbers are written with a dot instead of comma. So you would see 2.5 instead of 2,5

Excel is reading in locale setting outside continental Europe and hence 2,5 is being read as a text -- i.e., two numbers (2 and 5) separated by a comma.

Ideal solution

1 - Check and ensure language locale setting is same across all Excel, Power App etc..

Alternate solution

2 - Replace comma by dot

Value(Replace(Dropdown.Selected.Value, ",", "."))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation