Saving Formatted Number

[Garry030424]

I have formatted a number field in PowerApps using TEXT() function.

Formatted Field looks like "123,234,234.00 K EUR"

Now, i want to save this as "123234234.00" (Number) in SharePoint List

Need directions to achieve this 

[anandm08]

hi @Garry030424 ,

you can change a Text to Number by using Value(...)

[v-mengmli-msft]

Hi @Garry030424 ,

Please try this.

You need to set custom number format in SP list firstly.

Then extract number in "123,234,234.00 K EUR" and update it to number column.

Value(First(Split( "123,234,234.00 K EUR","K EUR")).Value)

Patch(List,First(List),{NumberColumn:Value(First(Split( "123,234,234.00 K EUR","K EUR")).Value)})

Best regards,

Rimmon

[Garry030424]

This gives error saying that it cannot be converted to a number

[WarrenBelz]

Hi @Garry030424 ,

The conversion would be

Value(
   First(
      Split(
         YourText,
         " "
      )
   ).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 the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Garry030424]

@WarrenBelz , @v-mengmli-msft :

Solution Seems to work however i found certain things:

Below input gets stored:

123,,123.23k EUR --> Gets Converted into 123123.23

123,123.23 -> Gets stored as is

Below input doesn't work:

123,123.23k EU

1,23,123.23k EUR

1,23,,123.23k EUR

I was checking various scenarios while testing and found these cases

How can we manage this situation where user leaves certain portion of the standard text post the number or adds extra comma ?

also , can there be any more such issues someone can encounter ? 

[WarrenBelz]

Hi @Garry030424 ,

To remove the commas

Value(
   Substitute(
      First(
         Split(
            YourText,
            " "
         )
      ).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 the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Garry030424]

@WarrenBelz : Throws Error while submitting, says cannot convert to number

Lets say if i input: 123 or 123.11 then it submits

however if i input: 123.00k EUR or something then it throws error

[anandm08]

hi @Garry030424 ,

try this one:

// Assume your formatted text is in a variable or text input named TextInput1

// Step 1: Remove commas and non-numeric characters
CleanedText = Substitute(Substitute(Substitute(TextInput1.Text, ",", ""), " K EUR", ""), " ", "")

// Step 2: Convert to a number
NumericValue = Value(CleanedText)

// Step 3: Save to SharePoint
Patch(
    YourSharePointList,
    Defaults(YourSharePointList),
    {
        NumberField: NumericValue
    }
)

[Garry030424]

@anandm08 : Doesn't solve generic typos example if users types something like 123,123.23K EU where "R" is missing at the end