collection currency euro

(0) Share

Report

Posted on by Frans_365CH

231

Database: AWA SQL server

Hi,

I'm trying to convert the values by adding columns when im building the collection. But i need currency fields with a komma; like euro 1245,50

in the following line you see i try several things but noting works. Do you have any idea?

ClearCollect(factuurFooter,AddColumns(Filter('[Access].[Q_paFactuurFooter]',tbl_factuurId = setFactuurId),"ENetto", Text(Netto,"[$-en-US]#,##" ),"EBruto",Text(Bruto, "[$-en-US]##.00"),"EBTW",Text(BTW, "[$-en-NL]#,###0.00")));

Yes i have seen the new function in Flow for convert numbers, but i tried several things, can't get that working either.

Thanks a lot for any idea! That would be great!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
@Frans_365CH
Do you want the decimal to be separated by commas instead of dots for display?
Please try this, substitute comma for dot:

ClearCollect(factuurFooter,AddColumns(Filter('[Access].[Q_paFactuurFooter]',tbl_factuurId = setFactuurId),"ENetto",Substitute(Text(Netto),".",","),"EBruto",Substitute(Text(Bruto),".",","),"EBTW",Substitute(Text(BTW),".",",")))

Sik
Frans_365CH 231 on at

Like
a
(0)

Report
Copy link

Link copied!

Works perfect! Thank you! Have a nice day!
Frans_365CH 231 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sik,

It works, but...

I get now 3 decimal places like euro 250,125

This must be of course 250,13 (currency)

Any idea how i can solve this one?
Frans_365CH 231 on at

Like
a
(0)

Report
Copy link

Link copied!

I think currency values are not possible in collections, so i have used a flow now with the new number function. So i convert the values in flow first and load them in a collection now. maybe not the smartist way, but it works!