Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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

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 an...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
lbendlin
Super User
1 year ago

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