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?
Solved! Go to Solution.
Right now I have:
But this gives me a result of ,00 but doesn't calculate my values
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.
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?
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.
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 🙂
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights