Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Extracting data from website and creating an excel table

Posted on 22 Nov 2024 12:42:18 by 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 🙂
  • Newbie_27 Profile Picture
    Newbie_27 17 on 24 Nov 2024 at 17:19:07
    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
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,491 on 24 Nov 2024 at 02:58:09
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,111

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard

Featured topics