How to get json data from azure blob storage and send it to power apps dataverse using azure data factory

Question

I have JSON data in azure blob storage container. I want to get the data and create a table in power apps dataverse and store the data in that table. I am using Azure Data Factory for this. How can I do this? For eg: this is the json data

{
  "name": "Apple",
  "type": "Fruit",
  "weight": "100"
}

OUTPUT

Name   Type    Weight
Apple  Fruit    100

Answer 1

1. In Azure, create an application registration and set the API permissions to be able to access Dataverse/Power Platform.
2. Create a secret for this application registration
3. In your dynamics environment, add an application user and use the client ID from your registration.
4. Assign appropriate rights to access the tables it needs.
5. The Service principal ID is equal to the object id and the secret is your your client secret.

Answer 2

Input file in blob storage.

Create table in power apps.

Create Pipeline in ADF with Copy activity.

Add JSON file as Source and Power App as Sink.

Create Linked service as shown below

Provide necessary details.

Import Schema in Mapping tab. And Map both Schema as shown in below screenshot.

Finally run Pipeline.