Unanswered

How to create Dataverse table using power automate flow

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

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 or Sharepoint.

Regards,

Ravi.H

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

So you want to create the table as Metadata right ? Table and fields?

Was this reply helpful? Yes No
MarioRing 541 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

There is no dedicated connector for creating new tables (entities), but it should be possible to call Web API using standard power automate connector for HTTP requests. See more information here. I hope this solves your problem!

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

Like (0)

Report
Copy link

Link copied!

I am new to poweapps. Can you please guide me or steps to achieve this solution.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,714 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

I dont think there is a way available for the same.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous as mentioned by @MarioRing you can use Web APIs currently there is no connector available but can you please explain what is the idea of the business case around having to create the tables and columns from power automate.

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

Like (0)

Report
Copy link

Link copied!

How to use web api to create Dataverse table.
Business Requirement - I have extracted the lotus notes data into Json format. Using the Json data I need to create the DV table using power automate. Do not want to create manually.

Was this reply helpful? Yes No
MarioRing 541 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
In that case:
Open Microsoft Excel, go to Data -> Get data -> From File -> From JSON, and transpose your JSON data into table format.
Create manually a table in Dataverse that reflects your Excel data format. It is way much easier to do this once manually instead of creating automation that does this instead of you.
Import data from your Excel file into the previously created Dataverse table

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

Like (0)

Report
Copy link

Link copied!

Using web API is there a way to create Dataverse Table? please let me know how to proceed.

Was this reply helpful? Yes No
MarioRing 541 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous wrote:
Using web API is there a way to create Dataverse Table? please let me know how to proceed.
Yes, it is. Here is the documentation and sample. Using this feature makes sense only if you are going to create multiple tables continuously. In your case it looks like you have to do this only once, to prepare the data structure for import.

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

Like (0)

Report
Copy link

Link copied!

For this C# knowledge is required? please guide

Was this reply helpful? Yes No