Dear Experts,
I have made a table in Dataverse in my own environment. Then i have created a bot Power Virtual Agent that calls for a power automate flow. The automate flow has to fetch the data of the dataverse table and return it to the agent.
I use the action Dataverse List rows where i have to specify the table. But in the listbox are many tables but not mine.
What am i doing wrong. Is it perhaps because of another environment. How can i solve this?
Thank you in advanced,
Greetings,
Peter Kiers
Hi @PeKi72,
The list rows action would retrieve/find tables and its rows from the current environment/environment which the flow is saved into. So, the short answer would be: yes this is because it is in a different environment.
Either save the flow in the same environment as the bot or as workaround interact with the Dataverse Web API instead of the list rows action.
With HTTP requests you could point to the correct environment/org url and list rows from that other environment. I have written a short blog post about this workaround/approach:
https://www.expiscornovus.com/2021/03/14/how-to-use-the-dataverse-web-api/