Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : fqZniWlVZPuxbMhWVartya
Power Platform Community / Forums / Power Apps - AI Builder / Values not recognized ...
Power Apps - AI Builder
Answered

Values not recognized in receipt processor

Like (0) ShareShare
ReportReport
Posted on 9 Dec 2023 21:06:19 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:
AI Builder
  • polo1604 Profile Picture
    polo1604 160 on 11 Dec 2023 at 08:17:50
    Re: Values not recognized in receipt processor

    Perfect, thanks a lot !

  • Verified answer
    v-bofeng-msft Profile Picture
    v-bofeng-msft on 11 Dec 2023 at 08:08:25
    Re: Values not recognized in receipt processor

    Hi @polo1604 ,

     

    Please try this formula instead:

     

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

     

    Best Regards,

    Bof

  • polo1604 Profile Picture
    polo1604 160 on 11 Dec 2023 at 07:35:10
    Re: Values not recognized in receipt processor

    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

  • v-bofeng-msft Profile Picture
    v-bofeng-msft on 11 Dec 2023 at 01:31:36
    Re: Values not recognized in receipt processor

    Hi @polo1604 ,

     

    Please try:

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

     

    Best Regards,

    Bof

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Question for everyone : How are you using Create Text GPT in AI Builder?

Product updates

Microsoft Power Platform Community release plans