Problem with How to Create CSV table to include data obtained from Run a query against a dataset

[Anonymous]

Hi everyone,

I am attempting to create a flow which builds a csv file, based on a step which queries a dataset, and then send the csv as an email attachment.

I can get it to create the csv and send the email with the csv attached but the csv content only shows a count of rows, not the actual row data. This is all quite new to me so I guess it is because I do not have an array set up correctly to then split out custom rows as I saw on an online tutorial on this topic.

My flow queries the dataset successfully and then parses the JSON into FirstTableRows using the schema. However, when I later get to the Create CSV table step, I don't have access to the row variables that I need to populate the csv with....

Please can someone let me know what I am missing here ?

Many thanks !

[lbendlin · Accepted solution]

You are missing a couple of steps here. To "send the csv as an email attachment"  you first need to materialize the CSV into an attachment. 

Instantly using Power Automate create CSV file and send email attachment - Global SharePoint (global...

[Anonymous]

Hi @lbendlin 

Thanks for your input.

In my case I don't have Sharepoint but get the data from a dataset query.

So I have added in a step to Initialize variable of type Array as Name varFileAttachement.

Then after the Create CSV table action, I added in Append to array variable which adds the Output from Create CSV table to varFileAttachment.

Then in Send an email (V2) I have added varFileAttachment as the Attachment.

The flow runs but the email received has no attachment - what am I missing ?

Thanks

[lbendlin]

Step 8 in the document I linked to is the main step. Everything else is just prep work that you can replace with your own.

- Run query

- generate CSV table

- specify attachment name and content

- add attachments array to email

[lbendlin]

You are missing a couple of steps here. To "send the csv as an email attachment"  you first need to materialize the CSV into an attachment. 

Instantly using Power Automate create CSV file and send email attachment - Global SharePoint (global...