Re: Power Automate flow creation: load data from csv file to a Dataverse table
create array variable “varArray”
iterate through your CSV file rows, repeat the below for each row.
1. split your row and save it in a ‘compose’ action.
2. create another compose statement, create a JSON object like so:
{
“Col1”: (compose_output)[0],
”Col2: (compose_output)[1],
etc, etc
}
3. Append to varArray your JSON object.
exit iteration
you can verify your array contains your data now, it should match up to your CSV.
you can now iterate varArray and for each item in the array, parseJSON action with the schema you created in the JSON object (you can paste a sample execution so it generates the schema from example).
for each item, create the new Dataverse record by referencing your parseJSON action. Each column should be available by name, so Col1, Col2, etc. should be things you can select and format as you wish.
