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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to find table(enti...
Power Apps
Answered

How to find table(entity) name related to the view

(0) ShareShare
ReportReport
Posted on by 45

In my managed solution , I have a number of custom tables and on each table a set of views. During solution upgrade I get failure to one of the views (not found) and error shows the savedqueryid. I can find the view name from its id, but not the table it relates to. Is there a table(s) in Dataverse that contain :

-Entities (tables)

-Views (for each table)

I would like to be able to link the view to its corresponding table

In absense of sending me the Dataverse table names you could also send a query pulling all the tables(entities) with its views from the solution (I know the solutionid). 

 

Many thanks

I have the same question (0)
  • Verified answer
    Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on at

    the table savedquery contains a column called returnedtypecode containing the table logical name

    screen_savedquery.png

  • drhorg Profile Picture
    45 on at

    Thank you very much for reply GuidoPreite : can you please share how you got this info? 

    Also the screenshot from your reply is from the make.powerapps.com , or from an XRMToolBox tool?

     

    Thank you again,

  • Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on at

    The screenshot comes from my tool Dataverse REST Builder (inside XrmToolBox) with a Retrieve Multiple request (as Grid) on "savedquery" table and columns "name", "returnedtypecode".

    My tool does it with Web API but I checked with FetchXML and QueryExpression and the column "returnedtypecode" contains the info you are looking for.

  • drhorg Profile Picture
    45 on at

    Many thanks for your quick reply on my question/issue Guido!

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 > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard