Unanswered

Send the sharepoint list as excel attachment without storing the excel file

(0) Share

Report

Posted on by Agrawalramakant

Dear Team,

I have a usecase in which I have 2 sharepoint list. I want to read the content of list 1 using a filter from each item of list 2, then attach the content as an excel file to an email and send the emails.

I am doing it this way:

read the content of list 2
create a excel file in a sharepoint document library using a template
for each item in list 2
1. read list 1 with the filter
2. compose a json
3. add a row to an excel table using the json
4. read the file content
5. send an email using the file content as attachment

In this approach everything works except the excel file has only 1 entry in the email attachment where as the excel file in the sharepoint document library has more than 1 entry.

so I did the other approach

read the content of list 2
create a excel file in a sharepoint document library using a template
for each item in list 2
1. read list 1 with the filter
2. compose a json
3. add a row to an excel table using the json
list all the files in the sharepoint document library folder
apply to each file
1. fetch the file contents
2. send email with the email attachment

This approach works !

But in both this approach I am write an excel file which I do not need to, is there any way I can send the email with excel attachment without the need to write the excel file first as I have all the data with me.

Thanks a lot in advance!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
Hi @Agrawalramakant ,

If the Excel file is a CSV file ,then it is available. I've made a test for your reference:

read the content of list 2

Use a Select action to get the fields that you want

Create CSV Table

Send an Email

Best Regards,

Bof

Was this reply helpful? Yes No
Agrawalramakant 12 on at

Like (0)

Report

Thanks @v-bofeng-msft for the response.

But with this solution I am getting a CSV file as an attachment but not xls or xlsx
Is there a way in which we could send the xlsx attachment without needing to create one?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Agrawalramakant ,

I'm afraid there is no such an OOB function to send a xlsx attachment without create one. But you could use your original plan and add an 'delete file' after send the email.

Best Regards,

Bof

Was this reply helpful? Yes No
Agrawalramakant 12 on at

Like (0)

Report

Thanks for your response.

I tried yesterday to do it with Excel and it works but I had to give a delay of 2-3 mins. It works find if I have to send 5-10 emails but it would be a problem when I send 40-50 emails or even 100 emails.

I tried to parallelism the apply to each but the content of the email were mixed in these situation plus the excel content was also mixed between different entities and for some the files were not created.
Could you guide me something there?

Was this reply helpful? Yes No