How to create Dataverse Table using Flow

Anonymous · ‎03-15-2023

Hi

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

Anonymous · ‎07-17-2023

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

Stevieed · ‎07-18-2023

It doesn't make sense why you need to create table in this way, most likely you misunderstand how table works, can you please describe what is your need?

Anonymous · ‎07-18-2023

Hi

Actually I have extracted the lotus notes data in Json format. This Json data should be created as column in dataverse table using power automate.

When I am creating the FLOW, it asked me the select existing DV table name first. After selecting the existing table, then based on Json data the field mapping to be done. This is the manual process.

But I want to create DV table based on Json data using Power automate.

Stevieed · ‎07-18-2023

Why would you want to do that? do you have millions of colums and then millions x millions of dimensions of data in one table and then you have millions of tables?

Anonymous · ‎07-18-2023

This is the customer requirement. They do no want to do manually.

Stevieed · ‎07-18-2023

are you sure you not mistaken the difference between rows and columns?

you might want to ask them again.

if you have that many columns in a table that you cannot do without automation, sounds like you are trying to store the whole universe

Anonymous · ‎07-18-2023

They want to load all the data's into the single table.

Stevieed · ‎07-18-2023

First of all I don't think there is a way to automatically create columns using code or power automate flow with out of the box solution (ie, straight away solution)

Are you able to show us how the table looks like originally? or how the data set or your JSON looks like?

Anonymous · ‎07-18-2023

My Json data look like as below.

{

"Input": "",

"MIME_Version": "1.0",

"Form": "Test",

"BusinessGrpTX": "",

"ProductGrpTX": "",

"DefectTypeTX": "",

"DocAuthorNA": "Ravi H",

"DocDateDT": "[05/04/2007 03:32:04 PM GMT]",

"CategoryTX": "ANALYSIS",

"DefectCodeTX": "A03",

"TitleTX": "Grain Boundary Alloy enrichment",

"AttachRT": "my bold text \r\nmy italic text \r\nmy underline \r\nmy highlighted text ",

"Requestor": "CN=Ravi H/OU=US/O=xxxx",

"StatusTX": "Completed",

"RefNO": "0234",

"DocRefTX": "2007/0234",

"AuthoriserAN": "[Admin]",

"DefectDescriptionRT": "The problem of surface hot shortness in steels containing copper is well known. The phenomenon is due to a deterioration in surface hot ductility caused by the presence of copper rich phases at the surface. The latter are liquid at hot working temperatures and penetrate down austenitic grain boundaries, leading to break-up when the surface is placed under tension. Elements in steel more noble than iron such as Cu, Sn & Ni will not oxidise when steel is heated, and as scaling commences these metals become enriched at the surface. The effect is augmented by scaling rate , temperature, furnace residence time, and residual levels ( the latter particularly relevant to scrap remelted product ) \r\nTmy red colored text paragraph: he presence of grain boundary diffusion / penetration may be observed by etching in Oberhoffer's reagent which highlights Cu enriched grain boundaries, or quantified by EDS microanalysis. Test \r\n \r\nTesing by Ravi \r\n \r\nmy bold text \r\nmy italic text \r\nmy underline \r\nmy highlighted text \r\n \r\nmy bullet points below: \r\n\r\n<ul type=\"disc\">\r\n<li>b1 \r\n<li>b2 </ul>\r\n \r\nmy numbered content below: \r\n\r\n<ol type=\"1\">\r\n<li>point 1 \r\n<li>point 2 </ol>\r\n \r\nmy centered text \r\n \r\n \r\nmy <a href=\http://www.google.com/\>hyperlink</a> to google.com \r\n \r\n \r\nmy in-line image below: \r\n<img src=\"/astddefect.nsf/0/e80fd616cd0799d7652588db00250fc1/DefectDescriptionRT/0.746?OpenElement&FieldElemFormat=gif\" width=\"615\" height=\"336\"> \r\n \r\n \r\nmy basic table 2x2: \r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tr valign=\"top\"><td width=\"50%\">column heading 1 </td><td width=\"51%\">column heading 2 </td></tr>\r\n\r\n<tr valign=\"top\"><td width=\"50%\">text 1 </td><td width=\"51%\">text 2</td></tr>\r\n</table>\r\n \r\n \r\n \r\n \r\n\r\n<ol type=\"1\">\r\n<li>( Note Cu rich phases on the grain boundaries ) </ol>\r\n",

"UNID": "E80FD616CD0799D7652588DB00250FC1"

}