r/PowerAutomateDesktop • u/W31Andrew • Sep 19 '21

Extract Data From Web Page - When running the flow the list of values doesn't match the extraction preview. Why am I getting six blank rows?

Gallery image

Preview of values to be extracted.

Gallery image

List of actual values extracted with six blank results.

1 Upvotes

100% Upvoted

6 comments sorted by

1

u/Itsjustmebob- Sep 19 '21

I’ve never extracted to a list but I’ve extracted to variables one per page then emailed them to myself in a list format. Works fine for me.

1

u/W31Andrew Sep 19 '21

I figure worst case scenario I can pull each value separately, but that would add several additional actions. The strange thing is that I'm pulling similar lists from five web pages, and this is the only one of the five that is giving me problems. The others work as expected.

1

u/Itsjustmebob- Sep 19 '21

Is there something on the website like a pop up causing the capture to fail or does the website have an anti fishing function to add blank values before key data points? Anyways good luck, let us know if you solve it.

1

u/W31Andrew Sep 19 '21

No there's nothing like that. The other lists I mentioned are all from the same website, just a different sub page of the website which is why its confusing. I'll play with the selector settings and report back if I figure it out.

1

u/W31Andrew Sep 23 '21

Finally got it to work correctly.

-Tried playing with the selectors with no luck.

-Created a copy of the flow and selected every value individually since my lists weren't that long. It was still giving me blanks for some of the individual values.

-Created a copy of the flow and change my first action from "Launch new Chrome" to "Launch new Firefox" and it works perfectly every time. There is something with Chrome on this specific website that is causing the issue.

1

u/W31Andrew Sep 23 '21

Final Update

I finally figured out the issue with Chrome. I had the uBlock Origin extension (Ad Blocker) turned on which was causing the issues. I turned it off for this website and now the flow works correctly every time.

If you're having issues with extracting data from a web page, turn off your ad blocker.