web
You’re offline. This is a read only version of the page.
close
  • Generate Data Entity Workbook including field data types and length/attributes automatically from data management workspace

    Data Entity exports do not show field data types, lengths and attributes.  It also does not show a logical relationship for the related tables/entities. We have been asked by almost every client to provide these details up front so they can map their source data without trial and error.  What we found is that once an initial export is completed this data is populated in the table 

    DMFDefinitionGroupEntityXMLFields

    you can access this with a specific environment at using this url template.

    https://Your.D365.URL.Here/?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntityXMLFields&cmp=USRT&limitednav=true&lng=en-us

    We were able to extract the necessary details from this table manually in SQL. Using this data, we created the attached sample workbook. We would like to add a feature to automatically generate this workbook from the Data Management Workspace without manual intervention.  That would include:

    1) Summary Workflow Sheet

    2) Logical Data View - Context Diagram

    3) Data Model with field data types,  lengths, descriptions, help text, etc from the example

    4) Sample data extract tab

    Thank you

    Ivan

     DM - 006 - Customers-Example

     

     

     

     

  • Allow embedding a powerapp on a workspace listpage

    Allow us to embed a powerapp on a workspace listpage. For example on the credit and collections workspace The customer ID can be passed from the list page. There is no way currently to embed the powerapp other than filling an entire workspace area but it does not pass a parameter. Allow embedding it to the list page the same as we can today on a form. That seems to be a nature extension to allow this. this idea came out of a Yammer post from the Peap program. Jason Green from the Microsoft R&D team agreed this was a natural extension and recommended that I create this idea post.