Hi @Kaptea ,
There is an isInt() function, but this will not work for you as you need to also accept the + (plus) and may be the space character in the phone number string.
I present one method below. The flow examines each character of the phone number for a valid character (valid characters are 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, +, and space). For each character of the phone number, the flow will record a value of true for a valid phone number character, and false for an invalid character. If this list of true/false values contains a false value then the phone number string is not a valid phone number.
These are the actions of the flow:
The varValidChars contains a list of valid characters that make up a phone number:
[
"+",
" ",
"0",
"1",
"2",
"3",
"4",
"5",
"6",
"7",
"8",
"9"
]
Using the SELECT action: we examine each character of the phone number, and record true (for a valid phone number character) or false (for an invalid character):
*FROM:
range(0, length(variables('varPhoneNumber')))
*MAP:
if(contains(variables('varValidChars'), slice(variables('varPhoneNumber'), item(), add(item(), 1))), true, false)
If the output of the SELECT action contains a false value (i.e any invalid character) then this is not a phone number.
You could further improve the flow further by checking if the phone string starts with a + or a number, that it is of a certain length etc.
See: How to Extract Numbers from a String Using Power Automate
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site | Twitter | LinkedIn
