Unanswered

Create new custom Entity from JSON File

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I need to create new custom entity in PowerApps through Json file. I am using MS Common data model Schema definition file as an input file. I am not able to create entity based on the CDM Json file (attached).

It is considering the Json file in Row/Column format and generating different power query. I have to drill down upto attribute (only one attribute gets selected).

Could you please help me in Json file folder through which I can create custom Entity?

I have CDM in Json file format (attached).

Json-ImportSO-POC...

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Joel CustomerEffective 3,224 on at

Like (1)

Report
Copy link

Link copied!

so you are trying to use the cdm json and create fields in the cds? it doesn't work that way.
CDS is Microsoft's implementation of the Common Data model. The CDM in github is a reference designed to allow others to apply the CDM to their custom databases, not designed to extend the cds.
If you want to make custom entities in CDS, use the standard approaches to add fields and entities in make.powerapps, or you can do it programmatically like this
https://community.dynamics.com/crm/b/mscrmcustomization/posts/create-entity-and-bulk-attribute-with-data-import-in-ms-crm

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the information. I have follow up question. Can you please share me sample Json file to import data to existing custom entity ?

For Eg. My custom entity is CustomerV3

Fields are : Cust_ID, Customer_Name, Customer Add, Onboarding_Date, Email, TaxID

Was this reply helpful? Yes No
Joel CustomerEffective 3,224 on at

Like (0)

Report
Copy link

Link copied!

If you wish to import data to cds entity from Json, you can use a dataflow with the Json connector https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-and-use-dataflows

Was this reply helpful? Yes No