web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Values not recognized ...

Power Apps

Answered

Values not recognized in receipt processor

(0) Share

Report

Report

Posted on by polo1604

160

Hello,

I have built my first app with the receipt processor. Some values are not correctly recognized, for example I get

1,169 EUR /1

and I want only the value

1,169

How could I convert this to a proper value?

thanks für your suggestions

Polo

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @polo1604 ,

Please try:

Match("1,169 EUR /1","[0-9,]*").FullMatch

Best Regards,

Bof

Was this reply helpful? Yes No
polo1604 160 on at

Like (0)

Report
Copy link

Link copied!

hi @v-bofeng-msft

thanks for your reply. Instead of "1,169 EUR /1" I have to take the result from the receipt processor, right?

Sometimes I get items with comma, sometimes with dots, depending on the country of the merchant. For example "3.123 EUR /1" or "3,123 EUR /1" has to be converted in 3,123. With your Match function, I only get 3 as a result.

best regards
Polo

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @polo1604 ,

Please try this formula instead:

Match("1,1.69 EUR /1","[0-9,\.]*").FullMatch

Best Regards,

Bof

Was this reply helpful? Yes No
polo1604 160 on at

Like (0)

Report
Copy link

Link copied!

Perfect, thanks a lot !

Was this reply helpful? Yes No

Join the conversation