Answered

Cant extract webpage data from a UI element

(0) Share

Report

Posted on by Chick

Im trying to extract text from an element that is only visible on a webpage when hovered over. I have tried a couple of things but I cant seem to get it.

Below is the element inspected.

Below is how it is displayed when the bar is hovered over.

Any help would be much appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (13)

Answers (1)

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Have you tried using the Get details of web page action and then pulling the entire web page source? The sort of elements that appear when hovered are not actually loaded when you hover over them. The value is usually loaded when the page loads. So, the source should contain it. You can then use the Parse text action with regular expressions enabled to retrieve the actual value.

If you can show a snippet of the page source around the part where the value is, I can come up with a sample RegEx that you can use to retrieve it. Alternatively, you can also read a bit about regular expressions that work in PAD here: https://learn.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference and then use the following tester to test it until you get it to work for your use case: http://regexstorm.net/tester

I'd suggest you familiarize yourself with RegEx, as it is one of the most powerful tools you can use in your RPA flows.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
Chick 21 on at

Like (0)

Report

Here is the Snippet

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Can you copy and paste the HTML code instead of doing a screenshot?
Also, is the text itself always the same and it's just the percentage that differs, or can the text also be different?

Was this reply helpful? Yes No
Chick 21 on at

Like (0)

Report

The text will be the same but the Percent value will change regularly,
Here is the body of the page attached:
https://drive.google.com/file/d/1Pg-uUYA2K7hOXA-YGKVUKZJNCVXELUqR/view?usp=sharing

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
You can use the following regular expression to get the text and the percentage:
Scrap currently being crushed \(\d+.\)
Use it in a Parse text action, but make sure you enable the "Is regular expression" toggle.

This will return your text in the %Match% variable.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
Chick 21 on at

Like (0)

Report

It did not seem to work, I tried checking with a Display message set to output the "Match" variable and it just continued running with no popup. This is what I have the Parse text set to
This is my currently flow

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

If it ran without a pop-up, it either failed somewhere, or did not access the actions due to the switch condition not being satisfied. Try doing it without the switch enabled.

Was this reply helpful? Yes No
Chick 21 on at

Like (0)

Report

I did not seem to work with the switch disabled either, I keep getting an error on viewing what the variable has stored from the web page source now.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

Might be a bug in your instance of PAD. Maybe try to contact support. Also, try looking at the Application logs on the Windows Event Viewer if you can see any errors there that corresponds to the error that PAD throws. That might help debugging the issue.

Anyway, with the switch disabled, does the pop-up appear?

Was this reply helpful? Yes No
Chick 21 on at

Like (0)

Report

No , no popup appears at all, instead of the popup i have changed it to write the collected text into a text document, and double checked if the "Crushing..." was in it but it does not appear in the collected source page. Its in the elements tab of the inspected page.

Was this reply helpful? Yes No