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 / Web api - Query for al...
Power Apps
Unanswered

Web api - Query for all attributes in a solution

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Is there a query I can use to retrieve all fields that are part of a solution?

 

So if I have imported Sol. A with some field additions to contact, and then Sol. B with more additions to contact, I want to get only the fields for Sol. A

I have tried using solutioncomponents to get all component of type Attributes, but I get only small part of all attributes of the solution

I have the same question (0)
  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @Kobia,

    What is the exact scenario why you need this? The reason I'm asking is the solution packager is meant to deconstruct a solution into XML files which you can then commit into your source control (e.g. Git). Then you can leverage the source control goodness to analysis the difference and all. For Azure DevOps or GitHub, there are some build tools to facilitate this which is called Pack and Unpack actions. https://docs.microsoft.com/power-platform/alm/devops-build-tools 

    Hope this helps!

  • Kobia Profile Picture
    Microsoft Employee on at

    Hi @EricRegnier,

     

    I build a tool, based on excel to provide SI's with information and auto generated ERD, partly derived from a power apps environment. The user provides as input environment name(s) and solution prefix(es) to filter entities\attributes from an environment. I use power queries in excel to retrieve the metadata via oData.

     

    i checked also the xrmtools document generator to see if  there is some magic there (when selecting an environment) but is suffers from the same issue

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Are you trying to generate an ERD, if so confused with your initial post...
    Have you looked at Solution Packager? As mentioned, can extract it to XML files and then with PowerShell or .NET can perform your logic on the XML and compare...

  • Kobia Profile Picture
    Microsoft Employee on at

    I am trying to generate an ERD so I need tables\fields\relationships info for what is inside a single solution.

    I don't want any dependencies for the end user except having excel and credentials to his environment (so i can use odata connection), so he can run the tool again and again for whatever changes done in the environment, so having him use package manager will be an overkill... 

  • EricRegnier Profile Picture
    8,720 Most Valuable Professional on at
  • Kobia Profile Picture
    Microsoft Employee on at

    I did, however,

    1. My target visualizer is power bi (for showing the ERDs- showing display names, descriptions, relationships, different layouts of a solution -each showing some tables, allow easily moving entities around,...)

    2. I want the user to specify solution name(s), and not a list of tables

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 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard