Michael Ghebremedin Dynamics 365 Notes

Refresh DataFlow If you have an existing DataFlow and you would like to refresh it before its refresh time, one of the ways to use Power Automate Flow to trigger the refresh. After you have identified your trigger, all you have to do is use the Data Flow Action. Group Type : Environment or Workspace Group : is dependent on what you select on the Group Type, if you select Environemt like I did you will find your envoroment listed under Group. Dataflow : Name of you DataFlow DataFlow trigger If you have a scenario to run automation after a specific DataFlow has completed, you can use DataFlow Trigger When a dataflow refresh has completed The parameters are idential as the previous action. Thank you for reading :)

Virtual Entity made easy on Dataverse/Dynamics 365 CE. Connecting to External Data has a new look in Dataverse, this feature simplifies the cretion of Table for External Data (Virtual Entity). In the following blog I will walk you though on how to create Table on External Data Navigate to you solution New → Table Select Table from external data. for this example we are going to connect to SharePoint Enter your SharePoint url and click Next, this is going to pull all the List available on your SharePoint site Select the Appropriate List and Click Next Here you have the ability to change the column(field) name on your virtual Entity Click Next Before finalizing you can review or change to a different List Click Finish Here you have your External Data Table (Virtual Entity). Thank you for reading.

  The format for populate lookups as we know is: TableName(RecordId) In the latest updates of Power Automate Flow we have noticed few addition to lookups, these are the properties that are available: Table Name Type Value This will make it easy to populate a lookup field and save us time from searching the Table Name TableName(Value) In my example:Company Name(Table Name)(Company Name(Value)) One note this functionality so far is not available for existing older Power Automate Flows.

 How to Close/Resolve case from Power automate flow from your DataVerse Connector Add a New Row Table Name: Case Resolutions Subject: Add your subject here Case (Cases): incidents({Case Id Guid})

 Power Automate Flow Relate N-N records This is going to be a short and sweet post. To relate two records that are related N-N (Many to Many) you can follow this steps. In your Power Automate Flow search for Dataverse and select Relate Rows Table name   :- Entity Name Raw ID         :- Entity ID Relationship  :- Name of N-N relationship  Related with  :- Odata Id (Entity to be related)

This article will guide you on how to register an application with Azure Active Directory. Once the application has been registered you can use it on OAuth authentication for your various applications. Navigate to your azure portal → Azure Active Directory → App registrations → New registration Provide appropriate name → Register Once the registration has completed you will be able to access the Application (client) ID we will use it later to create Application Use in Dynamics 365 Navigate to Certificate & secretes→ New Client Secret Make sure to store somewhere safe The Secret ID Value Navigate to API Permission → Add a permission Select Dynamics CRM Click Add permissions Create Application User Navigate to Advance Settings→ Security → Users→ New User Make sure to change the form to “Application User” Enter Application ID that we created earlier and Save All the necessary informati...