Microsoft Dynamics 365 CRM Tips and Tricks
By Inogic
Skip to content
  • Blogs
  • D365 Apps
  • Inogic
  • D365 / Power Platform Services
  • Maplytics Docs
  • New D365 Apps Docs
    • Subscription Recurring Billing Management
    • Marketing4Dynamics
    • Gamifics365
    • Business Process Checklist
  • D365 Apps Docs
    • Alerts4Dynamics
    • Attach2Dynamics
    • SharePoint Security Sync
    • Kanban Board
    • Lead Assignment and Distribution Automation
    • Map My Relationships
    • User Adoption Monitor
    • InoLink
    • Click2Clone
    • Click2Export
    • Undo2Restore
    • Auto Tax Calculator

How to Retrieve Dynamics 365 CE Entity/Table Metadata through Power Automate (FLOW)

By Inogic | February 27, 2021
0 Comment

Introduction

In this blog, we will explore how we can retrieve Dynamics 365 CE Entity/Table Metadata using Power Automate (Microsoft Flow).

In some scenarios, we need to retrieve the entity metadata. For example, let’s say we want to get the Primary Attribute/Column’svalue of the entity which is selected in the ‘Regarding’ field of the Email dynamically. For this, we need to retrieve the entity metadata of that entity since regarding can be any entity and for each entity primary attribute name might be different.

In the Common Data Service (Current Environment) Connector, we do not have any direct action/step to get/identify the ‘Primary Attribute’ field of an entity.

But, fortunately, we can use the Invoke an HTTP request action of HTTP with Azure AD connector to read entity metadata.

Retrieve Dynamics 365 CE EntityTable Metadata through Power Automate

This connector allows us to send HTTP requests to Dynamics 365 CRM or CDS without having to perform any additional authentication process. Also, no Azure App registrations or bearer tokens required.

Given below are the steps to retrieve Entity Metadata using Power Automate:

1. Add an Invoke an HTTP request action by searching HTTP with Azure AD in your flow as shown in the below screenshot:

Retrieve Dynamics 365 CE EntityTable Metadata through Power Automate

2. Now, enter the base URL of your Dynamics 365 instance into the Base Resource URL and Azure AD Resource URI (Application ID URI) fields’ i.e. https://.crm.dynamics.com. Next, click on Sign in.

Retrieve Dynamics 365 CE EntityTable Metadata through Power Automate

3. Now, fill in the required fields. Set the Method to ‘GET’ and enter Url of the request along with the OData query parameters as below:

Here, we are getting entity name dynamically i.e., from the ‘Regarding’ field of our previous Email action.

Retrieve Dynamics 365 CE EntityTable Metadata through Power Automate

Note: If you enter the full URL in the above “Url of the request” field, then it must match the Base resource URL set in the connection. For e.g., in our case –

https://crmorg6.crm.dynamics.com/api/data/v9.2/EntityDefinitions?$select=IsDocumentManagementEnabled, PrimaryNameAttribute, LogicalName,EntitySetName&$filter=EntitySetName eq ‘accounts’

4. Save your flow and then trigger it. On a successful run, you can inspect the retrieved metadata as shown in the below screenshot:

Retrieve Dynamics 365 CE EntityTable Metadata through Power Automate

Conclusion

In this way, by using Power Automate you can successfully retrieve Dynamics 365 CE Entity/Table Metadata.

inolink

Category: Dynamics 365 Dynamics CRM Power Automate Tags: Current Environment, Dynamics 365 Power Automate, Power Automate, Retrieve Dynamics 365 CE Entity, Table Metadata
Post navigation
← Open Lookup Field Form in the same context of the Main Form within Dynamics 365 CRM/Power Apps Free up Dynamics 365 CRM storage Space, Manage Attachments, Ensure data security – Multiple benefits with one app SharePoint Security Sync! →

Follow Us!

Follow Us on FacebookFollow Us on TwitterFollow Us on LinkedInFollow Us on YouTubeFollow Us on InstagramFollow Us on E-mailFollow Us on Docs

Blog Series

  • Power Apps – Model Driven Apps
  • Power Apps – Canvas App
  • Power Apps Portal
  • Power Automate
  • Power BI
  • AI Builder
  • Dynamics 365 for Field Service
  • Dynamics 365 for Project Service Automation
  • Dynamics 365 for Mobiles and Tablets

Recent Updates

New Release: Business Process Checklist app for streamlining business processes in Microsoft Dynamics 365 CRM

Document Management Solution for your Dynamics 365 CRM – How to choose the better one?

Integrate Dynamics 365 Customer Engagement with SharePoint – The secure way!

Get valuable insights into CRM data with new-age smart Data Visualization apps – Kanban Board and Map My Relationships!

Visualize intricate details in Dynamics 365 CRM with finesse using latest Map My Relationships feature

Top 5 Reasons why Subscription and Recurring Billing Management is must for easy subscription management within Dynamics 365 CRM!

QuickBooks Online + Dynamics 365 CRM – Get Accounting & Sales Data on one platform with InoLink!

From beginners to experts – Shorten the journey of adapting to Dynamics 365 CRM with our advanced User Adoption Monitor app!

New Age Automation App to Clone/Copy Records in Dynamics 365 CRM with just 1 Click

1 Click is all you need to Undo, Restore / Retrieve Deleted Data within Dynamics 365 CRM!

Bid goodbye to export woes with Dynamics 365 CRM 1 Click productivity app – Click2Export

Alerts4Dynamics – New age Dynamics 365 CRM alert management solution to bridge the information gap!

Automatically set user availability while assigning leads in Dynamics 365 CRM – New Feature of our Lead Assignment and Distribution Automation!

Mailchimp integration with Dynamics 365 CRM – Sync Audience, Tags, Campaigns and more!

Gamification in Microsoft Dynamics 365 CRM – Set goals, Make them fun, and Everyone wins!

Recent Posts

  • How to restore an earlier version of deleted records within Microsoft Dynamics 365 CRM!
  • Outsourcing Dynamics 365 and Power Platform Development – Choose Inogic for Experience, Expertise, and More!
  • Microsoft Release 2023 Wave 1: Form creation and management in Real-Time Marketing – Part 2
  • Configure the Right Subscription-Based Pricing Model for Your Product within Microsoft Dynamics 365 CRM!
  • Microsoft Release 2023 Wave 1: Form creation and management in Real-Time Marketing – Part 1

Archives

SiteLock
Copyright © 2023 Inogic. All Rights Reserved
Iconic One Theme | Powered by Wordpress