Extract data from web page

(2) Share

Report

Posted on by CU12050101-0

116

Hi everyone,

I’m working on a Power Automate Desktop flow where I want to check the values shown on a web page (screenshot attached). If the value is "0", I want the flow to throw an error or take a specific action.

To do this, I tried using the “Extract data from web page” action. However, when I try to extract the entire HTML table, it also includes some unwanted data like time, which I don’t need. I only want to extract the specific values (e.g., Demand) without capturing the time or other irrelevant parts.

Could someone please guide me on:

How to extract only the values I need (not the time)?
Or is there a better method to detect if the values are 0 and then trigger an error or alternate flow?

Thanks in advance for your help!

Categories:

Power Automate Desktop

Extract.png

I have the same question (0)

All responses (14)

Answers (7)

Verified answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

Capture the first two cells on the first column you want to capture (named Demand). Then the Live web helper should automatically extract the whole column. Then just take the first cell value from the next column you want to extract (named Virtual) and it should take all the rows for those two columns.

For example I take the Name column:

Second cell capture:

After I captured the second cell it automatically takes all the cells in that column

Then if I want to capture the Office column I just take one cell from the Office

Then automatically it returns all the rows in that column and I have both Name and Office columns captured:

https://learn.microsoft.com/en-us/power-automate/desktop-flows/automation-web

Another option would be to extract the whole HTML table and just remove the unwanted columns with "Remove columns from data table" -action

Was this reply helpful? Yes No
CU12050101-0 116 on at

Like (0)

Report

Thank you so much for your detailed explanation! I know it was a silly question, but I really appreciate you taking the time to explain it so clearly.

Also, I want Power Automate to display a message if any of the data become 0. As you can see in the screenshot, the Demand column has data that changes, but on the right side, the whole data shows 0. I want Power Automate to show an error message if the data becomes 0.

Could you please help me with how to set this up? I would be very grateful for any guidance.

Thanks again!

0.png

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

Great to hear my answer helped you! Happy to help :)

Use "Find or replace in data table" -action to the extracted table.

Then have If condition that checks if DataTableMatches has more than 0 rows in it. And if so then Display message

Display message -action:

Error popup window:

Was this reply helpful? Yes No
CU12050101-0 116 on at

Like (0)

Report

Thank you again! I was able to get an error message whenever there is a 0, so that worked perfectly.

Now I have another question. On a different page, instead of 0, the values are usually text like "Stop" (as shown in the screenshot). I want to display a message whenever "Stop" appears in the data.

I tried using the same actions and just changed the condition from 0 to "Stop", but I’m not getting the message when I run the flow. Could you please let me know what I might be doing wrong, or how I can correctly detect the word "Stop" in the data table?

Thank you so much again for your help and time! 🙇‍♀️

stop.png

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

Hi again 😊

Can you share the flow you built for this so I can maybe spot the problem

First I would check that your new Extract data from web page -action is working as needed. So is it returning the table correctly? Does it have the column which has the "Stop" values in it? If so then open the datatable and check that the value is exactly "Stop" and not for example " Stop " with spaces around it.

So for example if I wanted to check the second rows "office" column value I can just open that variable table and double click the cell value to see if it contains just the word "London" or also some spaces.

Or disable the "Match entire cell contents" toggle so that it finds the "Stop" even though there is some other characters in the cell.

Just make sure that there cant be cell value with "Do not stop" or dystopian since those values would have the text "stop" in it and there for get found by that action and your flow would pop up the error message.

Was this reply helpful? Yes No
CU12050101-0 116 on at

Like (0)

Report

Thank you for the quick reply!

I tried to check the variable by double-clicking it as you showed in the screenshot, but I wasn't able to do that on my side. I’ve attached a screenshot of my flow — could you please have a look and let me know if I’m doing something wrong?

Really appreciate your help as always!

Screenshot 2025-0...

Screenshot 2025-0...

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

Ah I forgot that with datatables you have to have the flow running but paused to view the individual cells of it. Looking at datatable variable is different when the flow is finnished vs when its paused (because you can edit the values when the flow is running for testing purposes). So after using Extract data from web page -action add a debug to the next action (click the action number and a red dot should appear to that action). Then look at the data table produced

vs when the flow status is Ready as in not paused:

You could also check it by using Set variable to set that certain cell value to a single variable so then even after the flow is not running you can see the value.

So get the certain value with %DataFromWebPage[row][column]% You can give column by name or by index (indexing starts from 0 so second column would be 1)

I suggest you try using Regex to match "Stop" with spaces removed. Regex: (?<=\s*)Stop(?=\s*)

Then check the DataTableMatches -variable if that returned anything

Was this reply helpful? Yes No
CU12050101-0 116 on at

Like (0)

Report

Hi,

Actually, instead of "Stop", the actual value in the table is "停止", which means "Stop" in Japanese. I already checked and there is no extra space around it. However, Power Automate keeps saying that "停止" is not present in the table.

If you look at the screenshot I attached, you’ll see that "停止" is clearly visible in the extracted table, so it should be detected. But for some reason, Power Automate is not able to catch it.

I think I might be doing something wrong in the process. Could you please take a look and guide me?

Thanks in advance!

1234.png

Screenshot 2025-0...

variable.png

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Your If condition is wrong. It asks if %DataTableMatches% tables row count is more than the string "停止" when it should ask if its more than 0 to see if "Find or replace in datatable" -action found any matches.

Was this reply helpful? Yes No
CU12050101-0 116 on at

Like (0)

Report

You were absolutely right—my if condition was wrong. Thank you so much for your help!

I also wanted to ask: In my screenshot, you can see the "Stop (停止)" error is under the column 102_A4056. How could I generate a message like "Error 'Stop (停止)' is under column 102_A4056" dynamically?

Thanks again for your time and expertise!

102.png

Was this reply helpful? Yes No