Web Data Extraction Flow

(0) Share

Report

Posted on by Learner1955

Hello!

I wonder if there is a way to create a flow that will get data from an Excel cell and search each number on a website.

For example: 200 USPS tracking numbers that I would have to enter one by one on the usps website Welcome | USPS in order to find the tracking information for each tracking number.

Is this possible?

Thank you!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Yes, with Power automate Desktop, Depends with Cloud,
For Cloud you would need one of these
1) the company you want to track with, has an API you can call, and you can use the HTTP Connector to call it
2) or the company already built a connector
3) they have an API and you build a custom Connector

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Learner1955 9 on at

Like (0)

Report

Thank you! I am very new to Power Automate.
I found a tutorial on Youtube that will help me achieve what I am looking for but, I am stuck at the "Send keys" part. It is not working. Any idea why this is happening?

Screenshot 2023-1...

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Its hard to answer for sure as there could be a lot of reasons. My guess though is that since its a web page, it doesn't have what is called a "default" handler for the carriage return. And that you would need instead, to use the mouse to click the button.

So have it recording you clicking the button that you are hoping the return is triggering. I don't see a screenshot of the site, so I cannot say what you are supposed to click, but usually they have a submit, or ok or track or something to click.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No