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