How to validate a WhatsApp number?

(0) Share

Report

Posted on by EmilioRoqueta69

565

Hi,

Using this example:

https://youtu.be/MMIvU3OxyWE?si=HikJddQvOF4DTxdg

I am reading an Excel file and send the messages thru Web WhatsApp.

But, when the phone number is wrong, I have no way to fix it.

This message appears, but I couldn't find a way to know and take any action.

It would be useful to be able to know that this occurred to alert the user in some way.

Someone made something about it ?

Thanks for any help!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report

@EmilioRoqueta69

Please ensure the WhatsApp URL works by entering it directly into the browser. If it functions correctly, then proceed to automate that URL.

Note that the number mentioned in WhatsApp must already be saved in your contacts and associated with a WhatsApp account.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report

Hi Deenuji,

Inside the flow, I am opening https://wa.me/phonenumber, and I cannot get if this url fails, because the url opens and shows some message.

Best Regards,

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report
@EmilioRoqueta69

This is one of my old project in WhatsApp based automation. Please take a look and see it helps you.

Follow the below Steps:
Launch Excel and Open File Under Existing Process:
Open Excel and load the specified Excel file under an existing process.
Path: C:\\Users\\deenu\\OneDrive\\Documents\\Booking Details.xlsx
Read Data from Excel:
Read all cells from the opened Excel file and mentioned the first row as a header.
Store the range of values in a variable named ExcelData.
Launch Edge Browser and Attach to Specified URL:
Open Microsoft Edge browser.
Attach to the specified URL: https://web.whatsapp.com/.
[In my scenario, I have accessed my web-based WhatsApp, completed the validation process, and it's in a ready-to-use state. then I have attached this instance with my browser]
4. Loop Through Each Row in ExcelData:
For each row in ExcelData, do the following steps:
Set Message and Phone Number:
Set the message to the value in the first column (index 0) of the current row.
Set the phone number to the value in the second column (index 1) of the current row.
Construct WhatsApp URL:
Construct the WhatsApp URL with the phone number and message.
URL format: https://web.whatsapp.com/send/?phone=%PhoneNumber%&text=%Message%
Navigate to WhatsApp Web Page:
Navigate to the constructed URL using the Edge browser instance.
Set a timeout of 60 seconds for the page to load.
Wait for Page Content to Load:
Wait until the specified element (Whatsapp send button)

appears on the WhatsApp web page.
Press the Send Button:
Click on the send button on the WhatsApp web page.
Set a timeout of 60 seconds for the page to load.
5. End of Loop.
Excel:

Flow Details:

Output:

Code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\deenu\\OneDrive\\Documents\\Booking Details.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData WebAutomation.LaunchEdge.AttachToEdgeByUrl TabUrl: $'''https://web.whatsapp.com/''' AttachTimeout: 5 BrowserInstance=> Browser LOOP FOREACH CurrentItem IN ExcelData SET Message TO CurrentItem[1] SET PhoneNumber TO CurrentItem[0] SET URL TO $'''https://web.whatsapp.com/send/?phone=%PhoneNumber%&text=%Message%''' WebAutomation.GoToWebPage.GoToWebPage BrowserInstance: Browser Url: URL WaitForPageToLoadTimeout: 60 WAIT (WebAutomation.WaitForWebPageContent.WebPageToContainElement BrowserInstance: Browser Control: appmask['Web Page \'https://web.whatsapp.com/\'']['Span \'send\' 3']) WebAutomation.PressButton.PressButton BrowserInstance: Browser Control: appmask['Web Page \'https://web.whatsapp.com/\'']['Span \'send\' 2'] WaitForPageToLoadTimeout: 60 END

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report

Hi Deenuji ,

Thank you for sharing!
My flow is very similar, but I do not see when you manage the error for a possible wrong number.

Thanks for you time!

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@EmilioRoqueta69

I don't get your question. What you want to validate here?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Deenuji

I think @EmilioRoqueta69 needs to handle this popup when validating whatsapp number as shared earlier-

You have to use wait for web element action and check using condition whether webpage /element is loaded correctly or not

Hope this helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No