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
Solved! Go to Solution.
Hi @VSJadhav
Follow the below steps:
Next section describes the No condition steps
Above I have used formatNumber expression.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogChecking 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).
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 -
Pat
To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.
Hi @VSJadhav
Follow the below steps:
Next section describes the No condition steps
Above I have used formatNumber expression.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog