web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Web Scrapping of respo...
Power Automate
Unanswered

Web Scrapping of responses from copilot of multiple pormpt

(0) ShareShare
ReportReport
Posted on by

 

Hello Everyone,

 

We have a list of prompts in excel. We want to search every prompt in copilot and extract the response in excel. is it possible with power automate

I have the same question (0)
  • Anil_g Profile Picture
    668 Moderator on at

    @Muddassir 

     

    You can do that…but rather than web scrapping it would be good if you can use api…that way retreiving of data is easier and reliable..

     

    with chat interface ui might not be viable solution..but we can still dot ht but not an ideal way

     

    cheers

  • Deenuji_Loganathan_ Profile Picture
    6,250 Moderator on at

    @Muddassir 

     

    If you're referring to Power Automate as the cloud version, then you have access to all the pre-built actions available in Power Automate Cloud. You can simply use the 'Excel - List rows' action, and consume AI Hub or Dataverse actions to interface with Azure OpenAI. It will then respond in JSON format via an API call, which you can read and save in Excel as needed.

     

    If you're attempting to achieve this with Power Automate Desktop, you can also create a 'Chat with GPT' action, similar to what we do in the cloud, and save the response back into your Excel file according to your use case.

     

    Deenuji_0-1718692020415.png

     

     


    Thanks,
    Deenuji Loganathan 👩‍💻
    Automation Evangelist 🤖
    Follow me on LinkedIn 👥

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 605

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard