Answered

Using Flow to send Email to Recipients from CSV File

(0) Share

Report

Posted on by RadVine

Following Task is planned to realize using Flow.

Frequently list of company user emails gets exported from a system as CSV file. We cannot maintain a distribution list of the constantly changing users but have easy export to CSV.

There is a limit to how many recipients a mail can have from Exchange Portal. Due to security reasons we don't want to increase that limit.

Flow watches for new entries of a Sharepoint list. Sends a Mail with Subject, Text from the List with the csv Attachment as recipients. If the CSV has more than 500 entries it splits the List in first 500, second 500 buckets and sends 2 or 3 mails after another from a shared mailbox.

My current issue is that Get Attachments always expects more than one attachment, resulting in a for each, we do not need.

The "Create CSV Table" block is expecting an array, not an actual CSV.

Another solution would be to store a Recipientslist.csv in a DocLib. How to format the recipients list from csv so we can use it with send an email v2 from a shared mailbox?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@RadVine

Compose 2 contains all employee email separated by semicolon which you can use in send email action.

Note- All excel connectors work only when your excel has table. if your CSV does not have table please use format as table.

Thanks
Hardesh

Was this reply helpful? Yes No
Rohit Sharma354 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

The approach mentioned by @Hardesh15 should work in your scenario. You can leverage output of compose in "send an email" action TO line.

Was this reply helpful? Yes No
RadVine 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response.
I did that (and a select of the right column) but apparently the selected table only holds 256 of the necessary 3400 mail addresses we would like to have. Quick googling showed that there is a limit to the connector.
Is there a way of splitting and selecting specific rows of this table and skipping empty table rows? (like row 1-255; 256-512; 513-768 aso. to workaround that limit?)
Not sure what oData is capable of.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RadVine

Right click on "..." and go to settings and enable pagination and set limit 5000. Then it will take all your entries.

O-data: it allows you to filter your data based on query. Suppose you want to filter data between two dates then you can use this option. It will give you only selected date range data.
Top Count- you can define how many count flow pick from top. suppose you defined 1000 and your excel has 2000 then it will pick 1000 from top.

if it solves your problem please mark this as solution.
Thanks
Hardesh

Was this reply helpful? Yes No
Verified answer

RadVine 34 on at

Like
a
(0)

Report
Copy link

Link copied!

I was still not able to get the CSV attachment into a workable file. Would still be interested in making it work with attachement content (1 file) and iterating through each element to make several BCC sending Lists.

Here is a workaround I managed to put together with a table formatted xslx and the Limits set to max (5000 Rows)

Was this reply helpful? Yes No