Create csv file and sent as attachment

(0) Share

Report

Posted on by TimmyBoy

997

Hello,

I got an email with my code

But still not attachment inside?

What do i wrong

Thank you

ClearCollect(
 CSVCollection;
 Concatenate(
 "Title,Item,Price";
 "\n";
 Concat(
 colCartData;
 Concatenate(
 "Title";
 ",";
 "field_1";
 ",";
 "field_9";
 "\n"
 )
 )
 )
);;

SMTP.SendEmailV3(
 {
 To:"demo@email.com"; 
 Subject:"Test subject csv";
 Body:"hi, you have a copy of the csv file";
 attachments: Table(
 {
 FileName: "myCSVfile.CSV";
 ContentData: Concat(CSVCollection; ",");
 ContentId: "1";
 ContentType: "application/octet-stream"
 }
 )
 }
)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Try something like this:

ClearCollect( CSVCollection; Concat( colCartData; ThisRecord.Title & "," & ThisRecord.field_1 & "," & ThisRecord.field_9 & "\n" ) ); // Add the column headers Set( CSVString; "Title,Item,Price\n" & CSVCollection ); SMTP.SendEmailV3( { To:"demo@email.com"; Subject:"Test subject csv"; Body:"hi, you have a copy of the csv file"; attachments: Table( { FileName: "myCSVfile.CSV"; ContentData: CSVString; ContentId: "1"; ContentType: "text/csv" } ) } )

Replace Title, field_1, and field_9 with the actual column names you have in your colCartData collection

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like (0)

Report
Hello @Rusk
Seems we have an error

These are the actual column names 🙂
colCartData; ThisRecord.Title & "," & ThisRecord.field_1 & "," & ThisRecord.field_9 & "\n"
But sending the mail there is still no attachment

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like (0)

Report
Hi @Rusk ,
Okay, seems i got a part working 🙂
I have the attachment
But when opening the csv, there is no data or even the Headnames
What do we wrong?
Updated code:
ClearCollect( CSVCollection; Concat( colCartData; ThisRecord.Title & "," & ThisRecord.field_1 & "," & ThisRecord.field_9 & "\n" ) );; // Add the column headers Set( CSVString; "Title,Item,Price\n" & Concat(CSVCollection;Value) );; SMTP.SendEmailV3( { To:"demo@mail.com"; Subject:"Enter email subject here"; Body:"Enter email body here"; Attachments: Table( { FileName: "myCSVfile.CSV"; ContentData: CSVString; ContentId: "1"; ContentType: "text/csv" } ) } )

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Maybe it's because "ThisRecord.Title" is being used, instead of a specified column name? Not sure... we can try this:

ClearCollect( CSVCollection; Concat( colCartData; Title & "," & field_1 & "," & field_9 & "\n" ) );; // Add the column headers Set( CSVString; "Title,Item,Price\n" & Concat(CSVCollection;Value) );; SMTP.SendEmailV3( { To:"demo@mail.com"; Subject:"Enter email subject here"; Body:"Enter email body here"; Attachments: Table( { FileName: "myCSVfile.CSV"; ContentData: CSVString; ContentId: "1"; ContentType: "text/csv" } ) } )

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like (0)

Report

Hi @Rusk
Sorry, same result
The csv file is empty
This is the result in my collection
There is data, but nothing happening in the csv?
Can you help me further please?
Thanks

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like (0)

Report
Hello,
It's been a few month i asked this question
And still i didn't managed to fix this issue
How can i fill the contentData to my filename
Because my file myCSVfile.CSV is always empty.
Attachments: Table( { FileName: "myCSVfile.CSV"; ContentData: myCSV; ContentId: 1; ContentType: "text/csv" }
Create the csv contents:
UpdateContext( { myCSV: "NAME1;NAME2;NAME3;NAME4" & Char(10) & Concat( colmycsvData; Title & ";" & field_1 & ";" & field_2 & ";" & field_3 & Char(10) ) } );;
Thank you

Was this reply helpful? Yes No