Answered

How to ignore letters and continue only with numbers

(0) Share

Report

Posted on by AnOO82

Hello everyone,

I build a flow which reads out barcodes from documents. Unfortuantly it also reads out QR-Codes and therefore I need to eliminate all outputs with letters.

I tried an filter array but I got the error:

'The template language function 'less' expects all of its parameters to be either integer or decimal numbers.

Does someone can help? Thanks in advance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (11)

Answers (1)

Sort by

ThomasFonn 273 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AnOO82
If you use the "parse text"-action, you can use a regular expression that matches the barcodes such as

^\d{5,7}

This expression can be read as follows:
^ = start of the line
\d = digits
{5,7} = atleast 5 characters, up to 7
And all these conditions must be met in order for a match
Image from Regex101.com of the matches

The ",7" is just there as an example, you can remove it or change it to another digit in case the barcodes lengths differs in the future

Best regards
Thomas Fonn

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AnOO82

Are you trying cloud flow or desktop flow ?

Was this reply helpful? Yes No
AnOO82 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nived, it's power automate cloud flow

Tried the barcode value row, but still don't know how to select all the numbers from the action 'read barcode'

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AnOO82

So Read barcode Document's output is the json object which u are showing first post ?

right ?

Was this reply helpful? Yes No
AnOO82 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, thanks correct 🙂

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AnOO82

could you show me the json output again, just to confirm

also tell me what you want to remove specifically from it

Was this reply helpful? Yes No
AnOO82 41 on at

Like
a
(0)

Report
Copy link

Link copied!

This is the outcome:
now I don't want to split the documents at https:/... oder other outcome bull**bleep**- i only need the numbers e.g. 00561, 00560, 0059...

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AnOO82

See this sample flow

It is filtering the array and checking if any numbers are there and filters it out

output of filter array would be like

Hope this helps !

Was this reply helpful? Yes No
AnOO82 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, that looks much better

Now the only problem is, that I really only want the number with 5 digits.
How can I change the function?

Was this reply helpful? Yes No
AnOO82 41 on at

Like
a
(1)

Report
Copy link

Link copied!

Adjusted the code to : @And(equals(length(string(item())), 5), equals(isFloat(item()), true))
and it's works 🤗

Was this reply helpful? Yes No