Unanswered

How to create Dataverse Table using Flow

(0) Share

Report

Posted on by Community Power Pla...

I am having data in my Azure storage account as Json file. Using this Json data how to create the dataverse table using Flow. Please help me on this.

Regards,

Ravi

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (22)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

Are you trying to create the table or are you trying to create a row / record in the table?

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

Like (0)

Report

I am trying to create the table first then create the row/ record in the table.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

I would suggest creating the table manually in a Solution (to support ALM processes) and then create the records through the integration which would be straight forward. You should be able to take the JSON response and map into a creation of the record in Dataverse.

Let me know if you need details on those steps.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

How to add record to Dataverse through Power Automate link: https://learn.microsoft.com/en-us/power-automate/dataverse/create

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

Like (0)

Report

I do not want to create the table manually. I want to use FLOW to create the table and import the JSON data from AZURE STORAGE ACCOUNT.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Sorry @Anonymous ,

hopefully someone can help you with this approach. Never tried this in past in Dataverse.

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

Like (0)

Report

I need soliution for the below one.

I do not want to create the table manually. I want to use FLOW to create the table and import the JSON data from AZURE STORAGE ACCOUNT.

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

Like (0)

Report

I do not want to create the table manually…I want to use Power automate FLOW to create the table and import the JSON data from Azure storage account

Was this reply helpful? Yes No
Static 118 on at

Like (0)

Report

Hi, @Anonymous

You can use dataflow.
Next.
Select you JSON file. and click TO table
Next click expand button and select all columns
and map all columns. You can select existing table or create new one. Run dataflow

Best regards,
Anton Nyrkov

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

Like (0)

Report

I do not want to create the dataverse table manually. I want to use power automate to create Dataverse table.

Was this reply helpful? Yes No