Number and currency formating

[MJ_RT]

Hello,
There are plenty of threads about number formatting posts, but couldn't find one that matches my issue, hence I would appreciate your assistance.
German number and currency format is 1.234.567,89

I have a excel file that I use as lookup then patch into SharePoint list

The number is shown with , as decimal seperator

in powerapps however it shows as .

When saved in SP List it removed the decimal value

the PC local for currency and numbers are as following

SharePoint local is German.

I tried text(value(lookup),"[$-en-US] ###,###.00" or text(value(lookup),"[$-de-DE] ###.###,00" yet it was not successful.

hope I was able to provide as much Information as possible. Thanking you in advance.

[TheRobRush]

@MJ_RT  try this, and let us know how it works out for you. It works on my side.

"€"&Text(RoundUp(255842.25,2),"[$-de-DE]##.##,00","DE")

[MJ_RT]

@TheRobRush 
Unfortunately it didn't work

I added the formula changing the comma to semi colon (due to German local), however the . is not considered as decimal.

This error is not there when the . is changed to comma for decimal and it works

So I replace the constant number to lookup Result
LookUp(Source;Formula;Text(Result;"[$-de-DE]##.##,00";"DE")), the . still shows as decimal value

So I created another label to roundup the value in the lookup result. however I get an error
the result is text not number, and the roundup awaits a number.

Please note that both Labels are formatted as number, in excel the field is formatted as Number

The data in excel is a query from SQL DB. i am not sure if the query cause the issue.

[TheRobRush]

You cannot round up text, only numbers. So you will need to convert that control result to a value like this in your roundup.

RoundUp(Value(DataCardValue23_3.Text);2)

[MJ_RT]

@TheRobRush 

Thank you for your response, however it did not work.

it showed instead the number without decimal symbol. as if the . is a group symbol.

I used the formula

the result:

In excel it shows with Comma and is formatted as number.

I am not sure if I said that the number 52252.42 is a lookup result. is there something in the lookup function?

I tried Value and roundup before the lookup, the dot is removed and it shows the full number without decimals.

[MJ_RT · Accepted solution]

I solved this issue through adding a round down in the source excel file.