I've been searching for a few weeks but have been unable to conquer this task. I can get them to work by themselves but cannot get them to work together.
I have a Sharepoint table which has drop downs and attachments. When the drop-down "Complete" is selected, I want the below to happen :
1) Trigger a single line CSV to be created containing that row /headers which had the change.
2) Trigger the fetching of the attachments on this row
3) Create an email with the above 2 attachments.
Would very much like some help on this.
I think it is more reasonable and can be achieved is the attachment of item as an attachment to the mail, CSV table as the content of the Body part of the mail.
It seems that you need to create a new file with the output of Create CSV Table as the contents of the file, and then append it to the array, but I think it might be better to use CSV table directly as the body of the message.
Anyway, if you want to include the attachment contained in the item as an attachment to the mail, and the CSV table as the body of the mail, you can directly fill the variable in the Attachments field, and the output of the Create CSV table is filled in the Body.