How to ignore letters and continue only with numbers

[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.  

[ThomasFonn]

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

[Nived_Nambiar]

Hi @AnOO82 

Are you trying cloud flow or desktop flow ?

[AnOO82]

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'

[Nived_Nambiar]

Hi @AnOO82 

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

right ?

[AnOO82]

Yes, thanks correct 🙂

[Nived_Nambiar]

Hi @AnOO82 

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

also tell me what you want to remove specifically from it 

[AnOO82]

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... 

[Nived_Nambiar · Accepted solution]

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 !

[AnOO82]

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?

[AnOO82]

Adjusted the code to : @And(equals(length(string(item())), 5), equals(isFloat(item()), true)) 

and it's works 🤗

[Nived_Nambiar]

Hi @AnOO82 

That's good to know

Kindly mark the appropriate answer as solution so that we can close the topic !