Unanswered

Dataverse Table for Solution Table Schema - mapping from column logical to display names

(2) Share

Report

Posted on by rborghmans

We are trying to create a Power Automate flow that will retrieve the Dataverse table schema for a given table.

Currently we can see the Display name and name of a given column, but we would like to get that information in a Power Automate Flow.

The Dataverse connector to List rows includes a long list of tables, but finding the one that has the data I'm looking for has eluded me.

Does anyone know which Dataverse table includes this information?

Background: The "Audit" table in Dataverse contains the Audit History for records within Dataverse environment.

However, the "changedata" (See JSON below) within that table only includes logical names, and values (not Display Names and Labels) of attributes and their values.

We already found that we can find the mapping from the attribute values to their labels through the 'String Maps' table, but I've yet to be able to find the table where I can find the table schema to convert the attribute schema name to the display name. Ultimately we need this information to be able to export my Audit History for Part 11 compliant audit trails in Power Apps with human readable data.

{
"changedAttributes": [
{
"logicalName": "jg_gxpapplicability",
"newValue": "0",
"oldValue": "1"
}
]
}

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Shashank Bhide 946 Moderator on at

Like (0)

Report
Copy link

Link copied!

https://learn.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.messages.retrieveattributerequest?view=dataverse-sdk-latest

I'd suggest write a custom action and call that action from power automate.

Was this reply helpful? Yes No
MichaelFP 1,943 Moderator on at

Like (0)

Report
Copy link

Link copied!

I think for you the best approach is to use TDS connection and Build T-SQL to get this information it will much better and will have less cost to use the Power Automate.

Was this reply helpful? Yes No
JoshGlenn 31 on at

Like (0)

Report
Copy link

Link copied!
I'm still working on a better solution, but I finally found one possible solution using an API... Still requires some work, but the following API will pull the display names of all of a given table in Dataverse. It'll take some work to parse out what I need, but it is possible...

https://<org code>.crm.dynamics.com/api/data/v9.2/EntityDefinitions(LogicalName='jg_npsinventory')/Attributes/Microsoft.Dynamics.CRM.AttributeMetadata

To break down the API:

EntityDefinitions(LogicalName='<name>'): comes from the "API link to table definition" option available under the "Tools" menu for a given table. See Screenshot.

Attributes/Microsoft.Dynamics.CRM.AttributeMetadata: API function to expand the Entity Definitions to include the Attribute details. (See https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/attributemetadata?view=dataverse-latest).

After spending time on this I've concluded ultimately that doing a Power Automate flow for this problem isn't the best option for what we're needing to do, although I don't have the expertise to build something else. At this point a request has been submitted to Microsoft to have them fix the issue with the Export to Excel function for Audit History as that's ultimately the reason we were attempting to build this flow. If that gets fixed, there would still be a need to query the Audit History, but the general need would be satisfied and anyone needing to more specifically query Audit History would likely need to build a custom solution.

Was this reply helpful? Yes No