Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I want to make an canvas app in Powerapps where you can from a gallery one of the (custom) entities in CRM. After that I want to choose from the field(names) of that chosen entity.
I know how to make that happen in PowerApps. The problem I'am facing is that I can't find/get the entities or the fields going with that entity. I tried the following entities in CDS/Dataverse:
They all show up emtpy. Which table/entity do I have to choose to get a list with all entities in my App and after that which table(s) contain the fields per entity?
Thank you in advance!!
thank you very much for reaching out to the CRM Forum. I did not exactly understand, if you are facing the issue, that no entites/tables and attributes/fields are listed to choose at your gallery datasource, of if you want to get a list of all your (custom) entites and attributes retrieved, to list it at your gallery/CanvasApp itself.
So please let me explain, in case you cannot see the entities listed, for selecting at DataSource at your Gallery, please make sure, you created the CanvasApp at your particluar CRM/CDS environment selected, and not the default environment:
If you want to list all the entites and attributes of your CRM environment, there is no specific Table, at which all entities are listed and I also think, there is no out-of-the-box PowerPlatform Function availalbe, to do this.
But you can get the metadata and information about all your entites/tables and the attributes, using the WebAPI at your CRM/CDS environment. So it should be possible, you create a Flow or an Azure Function, which retrieves the WebAPI data (using http request or REST), and return the data back to your Canvas App.
To do so, you can use the WebAPI functions for EntityDefinitions, like:
This will return in oData v4 Format/JSON all the LogicalNames and DisplayNames of your environment, and the second request, will list all fields/attributes of the "account" entity for example.If you are further familiar with the WebAPI, you see, you can also add also different fields, like checking, if it's a customizable entity with the field IsCustomizable, or using the filter for IsCustomizable/Value eq true (https://<org>.crm.dynamics.com/api/data/v9.1/EntityDefinitions?$select=LogicalName,DisplayName,IsCustomizable&$filter=IsCustomizable/Value eq true)
For more information about the WebAPI function and a possible way, to do so with Flow, please have a look at the following URLs:
I hope, this information will further help you with your issue.
Thank you very much, please let me know, if you have any further questions on this or if this resolved your issue, have a nice day and please stay further healthy.
Thank you for your explanation Daniel!
Business Applications communities