Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
Answered

Do not find my table in Power Automate that i have created in Dataverse

(0) ShareShare
ReportReport
Posted on by 1,017

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

 

Categories:
  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 31,081 on at
    Re: Do not find my table in Power Automate that i have created in Dataverse

    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/

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics