Unanswered

how to set up dataverse table search in Power Automate

(0) Share

Report

Posted on by Jeanxyz

I want to use chatbot to read a Dataverse table and filter the table using prompts/questions from users.

Below is the PowerAppSearchFlow I have built using online tutorial. In the table filter, I used the table name from Power App. However, I got an error:

//"code": "SearchableEntityNotFound",

//"message": "No entities were found to be searchable. Please make sure that you have at least one entity selected.

That seems to suggest the API connection does work. However, I have enabled Dataverse search in Power Platform admin center. I'm using free trial license of Power APP, Power Automate and Copilot Studio.

As a test, I have changed the action from Search Rows to List Rows. The List Rows action should combine all rows and return a text string. This time the flow succeeds, but I only got a string of row headers in the chatbot. Real data rows are not parsed.

Thanks for help. @Agnius, @remidyon

search rows in dataverse table.PNG

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

adilei on at

Like (2)

Report

Does the table have "appear in search results" checked?

Was this reply helpful? Yes No
Jeanxyz 72 on at

Like (0)

Report

Thanks a lot. That works! Now I need to find a way to export Dataverse search results to the chatbot. I'm struggling with GPT prompt - key word extract and write Dataverse search results to an output table.
Below is the tutorial I'm trying to follow.
//https://www.linkedin.com/pulse/chat-your-data-using-only-power-platform-r%25C3%25A9mi-dyon/?trackingId=YNCw81N4SIK5PV79pQiSOw%3D%3D

Was this reply helpful? Yes No
adilei on at

Like (0)

Report

What functionality do you have in mind? Answering questions: e.g. how do I fix my espresso machine? or responding to analytical queries, e.g. show me unpaid invoices?

Was this reply helpful? Yes No
Jeanxyz 72 on at

Like (0)

Report

I would like to create a chatbot which can read dataverse table and return a filtered table, e.g.,
user question: tell me details about invoices from customer Microsoft.
chatbot response: a filtered dataverse table based on customer name search.
D_customer D_invoice id D_invoice date D_open amount D_overdue amount
Microsoft I100 45311 1000 1000
Microsoft I200 45311 2000 2000

Was this reply helpful? Yes No
adilei on at

Like (1)

Report

Then you shouldn't rely on search. You would probably need to convert a natural language query to fetchXML.

I'll try to post the steps for this pattern in a few days. Try to remind me if I forget tagging you?

Was this reply helpful? Yes No
Jeanxyz 72 on at

Like (0)

Report

Hi @adilei , do you have any news on the idea above? Needless to say, if this idea works, it's going to change the way human beings consume tables, we can also add more actions (e.g. sending invoice chasing emails) based on the filtered table.

Was this reply helpful? Yes No
adilei on at

Like (1)

Report

Hey @Jeanxyz ! thanks for reminding me. Hopefully will have something to share by mid next week.

Was this reply helpful? Yes No