News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Extracting data from w...

Power Automate - General Discussion

Unanswered

Extracting data from website and creating an excel table

(0) Share

Report

Report

Posted on by Newbie_27

17

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 🙂

All responses Img

All responses (2)

Answers Img

Answers (0)

Newbie_27 17 on at

Like (0)

Report

Extracting data from website and creating an excel table

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
Suggested answer

Nived_Nambiar 16,877 on at

Like (1)

Report

Extracting data from website and creating an excel table

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 144,609

#2

RandyHayes 76,287

#3

Pstork1 64,420

Leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans