Unanswered

Format issue text vs number

(0) Share

Report

Posted on by Community Power Pla...

After I changed the format from number to text the currency gets visible in my datacard (wat wasn't visible if I've set format to number)

But right now I've set my format to text the field isn't recognized anymore as a number value.

So if I want to make calculations with those fields to other fields it gives errors/no response.

Like for example

Datacardvalue 1 (€1750,50) is formatted with ("[$-fr-FR]# ###,## 00","fr-FR") and set on text so I get €1 750,50 displayed.

Datacardvalue 2 (€2500,75) is formatted with ("[$-fr-FR]# ###,## 00","fr-FR") and set on text so I get €2 500,75 displayed.

If I want to sum datacardvalue 1 + 2 I should expect the result of € 4251,25, but it results in ,00.

So it looks like the datacardvalues won't be recognized as a number value anymore.

Do you have any idea's to solve this?

Thanks!

Ramon

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

eka24 20,923 on at

Like (1)

Report

Try:
Value(Datacardvalue1.Text)+Value(Datacardvalue2.Text)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Right now I have:
Text(Sum(Value(DataCardValue1.Text)+Value(DataCardValue2.Text)),"[$-fr-FR]# ###,00","fr-FR")

But this gives me a result of ,00 but doesn't calculate my values

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report

please I have tested your formula and it works fine. Don't convert the individual datacardvalues with the currency format.

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like (1)

Report

You can't format a number value. You will need to take the format off where the value is entered so it is looking at it as just a number value and then can put the format on the final amount that you can display as a text.

Basically if you want it formatted it is text and not a number.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @eka24 ,

So if I want to use the €0 000,00 value I only can use this as a "final" display screen? and not as a datavaluecard that can be used in other value fields?

Is it an Idea to make datacardvalues invisible and make an visable textfield to cover it? or will that have any con's aswell?

Kind Regards
Ramon

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Hi @Anonymous
Can you show exactly what you want so I adjust the formula for you. Give clear example what it is and what you want it to be.
Waiting for feedback

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@eka24

I think I have a solution:

When I format all datacardfields just as a number without "[$-fr-FR]# ###,00","fr-FR") format.
My result in my "total field will be 3350 in this example with formula: Sum(DataCardValue46+DataCardValue50+DataCardValue48+DataCardValue49+DataCardValue47) and set this visibility to false

Now I've created an text label with the formula : Text(Sum(DataCardValue14),"[$-fr-FR]# ###,00","fr-FR")
Just to use this label as the visible field and past it over the original datacardvalue and set this visibility to true

Now I get this as result:

Do you think this is a valid solution? because now I can use DataCardValue14 (in this case) in another formula in other fields.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

I think is ok. if any issue comes up, you can always give a feedback
thank you

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @eka ,

I've processed it in my app and it is some extra work, but it works fine for me.
Right now it's visible what I wanted to see and in Sharepoint I get the data I need.

Because your help i came op this idea, so i've selected that as the solution 🙂

Thanks again!
Ramon

Was this reply helpful? Yes No