Extracting data from website and creating an excel table

(0) Share

Report

Posted on by Newbie_27

Hello community,

I was looking to automate a task wherein I need to extract data from website (https://www.fda.gov/medical-devices/medical-device-recalls/2024-medical-device-recalls) and create a excel table in a file present in onedrive. The created excel table should have Device name as seen in link as hyperlink and date as per website.

Note: The device name should be a hyperlink as in website.

The data should refresh twice a day and all the data should be refreshed in excel as well.

It would be great to hear from the community

Thanks!

Newbie 🙂

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Just want to check - when reffered to refreshing part- does it meant the new data would be present and flow need to append the details to existing table / should it be overwriting the existing table data with new data which is scrapped?

Thanks & Regards,

Nived N

Was this reply helpful? Yes No
Newbie_27 17 on at

Like (0)

Report

Hi @Nived_Nambiar

i meant to say that the new data needs to be updated in

the existing table present in excel and flow need to run twice a day

Thanks!

Newbie

Was this reply helpful? Yes No