Extracting list of items from database

(0) Share

Report

Posted on by pasccout

I want to create a topic that gives users the ability to get a list of rows from a database (in our case, postgres).

I am able to use the connector and it does the select on the database and returns something (either record or table).

I want to parse the results and display one of the fields in a list return to the user (name column). I've tried all sorts of things like ParseJSON but that wants a string but the source is a table.

Has anybody done this type of selection from a database? Would be great if our users could ask for the list of items from the DB from Copilot.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I've done it. Basically you use a Flow to retrieve the filtered set of records and then use an Apply to each loop on the results to built out a table as a string using the Markdown language. You return that string and display it as a message in the bot. Here's an article on the markdown syntax you use. Use Markdown language to format Power Automate approvals - Power Automate | Microsoft Learn

There is no way to return a data set as a data set to the bot.

Was this reply helpful? Yes No
pasccout 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. So using the plug-in preview of Postgres directly within Copilot is not supported?

Was this reply helpful? Yes No
Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I misunderstood your question. I thought you were trying to access information in a DB for a bot. That is the process I described. I don't have any experience at this point using Postgres.

Was this reply helpful? Yes No
fernandosilva Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, you can use the HTTP connector. Make sure you have a body and place in it.
use, Compose and ParseJson and then send the response you want back to PVA.
That doesn't require Postgres or any other library for the outer world.
Simply using the connectors available, you can get all the data and pass it with a form, table, list, etc.

Cheers,

Fernando

Was this reply helpful? Yes No