cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Combining CSV and Images in 1 email

Hey Everyone,

 

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.

 

 Flow to Trigger an email with the attachments on that "job" in the SP tableFlow to Trigger an email with the attachments on that "job" in the SP table

What I have tried to do so far - Which results in only code in a blank fileWhat I have tried to do so far - Which results in only code in a blank file

2 REPLIES 2
Highlighted
Frequent Visitor

bump

Highlighted
Community Support
Community Support

Hi @Chris264,

 

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.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,158)