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

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / How can we fetch SQL d...
Copilot Studio
Unanswered

How can we fetch SQL database data as per user questions

(0) ShareShare
ReportReport
Posted on by 101
Hello,
 
I've website where first step is login page and after login fetching data based on logged in user. E.g. property, bookings, customer etc..
Now from CoPilot studio I need data based on user's question. Question could be in natural language. Find the example of questions.
 
1) Question: Give me list of all my properties
 Answer:  It should fetch data from DB/restAPI and give property names in table format
2) Question : Give all bookings data of "Sai Villa" property
Answer: It will give all bookings against that "Sai Villa" property with booking number, booking dates etc.. information in table format
 
So bottom line is that as per user query it should give dynamic data in table format.
 
Thanks
Categories:
I have the same question (0)
  • Suggested answer
    Artur Stepniak Profile Picture
    1,534 Super User 2025 Season 2 on at
    How can we fetch SQL database data as per user questions
    Hello,
     
    not sure about what's your question. Would you like to ask if it's possible or how to achieve these functionalities? Nevertheless, it's possible but it depends on the data that you have. You'd need to implement topics/actions to call the API based on the user prompt and then return GPT-generated answer.
     
    In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.
     
    Best regards,
     
    Artur Stepniak

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Copilot Studio

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 274 Super User 2025 Season 2

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 257 Super User 2025 Season 2

#3
Sam_Fawzi Profile Picture

Sam_Fawzi 82 Super User 2025 Season 2

Last 30 days Overall leaderboard