Add 10 digits numbers into #######-##-# format

[VSJadhav]

Hi Team,

Am using PowerApps portal application where am getting records from excel.
I want to check whether input field value is digit or not.
If its 10 digit number and does not have "-" present in specific places then add it else check whether "-" present in required places or not. If "-" present in wrong places then stop the flow and show error.

The required input to proceed ahead is #######-##-# or ########## and it should have digits only.

Please let me know how to create MS Flow for this.
Thanks,
Vaibhav

[mahoneypat]

Checking if a string is an integer is sadly not easy in power automate.  However, here is one way to check your input for a 10 digit number.  Also, see this article for how to configure the run after where shown (after the is10digitnumber step).

Microsoft Flow – How to determine a string is numeric? | @mydevexperience #Flownaut Super User III (...

This flow replaces '-' with '', check if the string length is 10, and then also tries to check if the int( ) of that string is >0.  The IsInteger variable is initially set to true and set to false only if the Is10digitnumber step fails.  The condition then checks that IsInteger is still true and that the number is 10 digits.

Key Expressions Used Above

Is10digitnumber step - 

and(equals(length(replace(outputs('InputText'), '-', '')), 10), greater(int(replace(outputs('InputText'),'-','')),0))

Condition control - 

and(equals(outputs('Is10digitnumber'), true), equals(variables('IsInteger'),true))

Pat

[abm · Accepted solution]

Hi @VSJadhav 

Follow the below steps:

Next section describes the No condition steps

Above I have used formatNumber expression.

formatNumber(int(variables('Number')),'#######-##-#')

Above I am using the error handler technique to verify whether the number is numeric or not. As you can see above the formatNumber have int() expression. If thats not a number this is going to fail.

Next below steps are for the Yes part of the condition.

Above formatNumber() expression is as follows:

formatNumber(int(replace(variables('Number'),'-','')),'#######-##-#')

Same error handling technique I used to determine the whether the number is numeric or not?

Note:

To set the error handling technique you need to set the following. Click the configure run after then select the option 'has failed'.

Above same technique you need to use for Compose 6 as well.

Thanks

Thanks