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?
Solved! Go to Solution.
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)
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
Hello,
The approach mentioned by @Hardesh15 should work in your scenario. You can leverage output of compose in "send an email" action TO line.
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.
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
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)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
7 | |
2 | |
2 | |
2 | |
1 |