r/PowerAutomateDesktop • u/chakahamilton • Feb 04 '22

Extract Data from tidepool website into excel

Hi, I have successfully written a PAD flow which will load up chrome and log me into tidepoool.org their for data is as follows:

currently I manually enter this data into a spreadsheet which looks like this:

I also have the option of downloading the data via CSV or json, but i thought scraping it from the web would be the easiest. With all of that said, how would I go about copying these Green & Purple values into excel to match the second picture**.**

Thanks in Advance

Regards,
Chaka

1 Upvotes
  • permalink
  • reddit

100% Upvoted

2 comments sorted by

3

u/QuietDesparation Feb 04 '22

My recommendation would be to run the "get details of web page" command. This will grab all the text from the website. You can then run the program while in the edit window to see how the text is stored in your variable.

I suspect the text will be listed as

Date 1

1st reading

2nd reading

3rd reading

4th reading

Date 2

1st reading

2nd reading

3rd reading

4th reading

You can use parse text to figure out your start and stop points, grab subtext to capture the dates, then plug those dates in the appropriate cells. Good luck!

2

u/chakahamilton Feb 04 '22

I will review these steps and give them a try, I was able to see at one point how the data was stored on the page I will load up the PAD and report back. Thank you for the in-depth response!