From Datasverse to Azure Blob and everything in between

(0) Share

Report

Posted on by futr_vision

831 Moderator

I have a table in the Dataverse created and updated by a PowerApp. Here is what I am trying to do.

When a row is added, deleted or modified I want to trigger the flow
I don't need all of the columns, so I need to pick which ones I want.
Change the column names.
Write the output to a CSV file.
Store the CSV file in Azure Blob (or possibly Azure File Storage)

It all sounds easy in my head but I get muddled with all of the options.

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (0)

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Hello @futr_vision

Please show us what you already got and where you currently stuck.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

I've added and deleted a number of actions but this us where I am at.

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Why do you need “Create Worksheet“? I thought you wanted to create a csv. There is a “data operations” action to “create a csv”. As far as I remember you can change the name and the number of columns with this action as well. You also can use the “Select” action to do that.

After that you save it to your blob storage using the output of create csv.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

I guess I don't have to. I had tried the Create CSV Table since that was the only one I could find but that prompted me with entering something in the "From" field. I tried some of the columns that were presented to me but the process ultimately failed.

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@{triggerOutputs()?............ is of type 'String'. The result must be a valid array.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

Actuallly, I do remember why I was creating a worksheet. I've been waiting for our team to provision me space on Azure Blob. I figured if I output to a worksheet I could at least see if it works. Maybe there is a better way. Probably just save to Sharepoint or something.

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

The csv action needs an array. You already have an array (value of list rows). This is what you need to use. Just give it a try. And of course you can save it to SharePoint as well to test it. Content is the output of the csv action.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
This seems to work but when I look at the output looks like

{ "body": A bunch of data }

Is that correct? Will that actual output look different in a CSV file opened in Excel?

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

Should have just tested. It works. Now, where in this flow do I pick the columns I want and where do I change the name of one of the columns?

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

I think I have figured it out. Now. My next struggle is that this can only run once. The next time it runs it fails at the create file action since the file already exists.

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

You can also change the values during create csv the same way you do with the select action.

For “File already exist” you have to think about what you want to happen. You could create the file with a timestamp or you replace the file or give it a new name. Depending on what you decide, your flow needs to be changed a little.

Was this reply helpful? Yes No