Power Platform Community Forum Thread Details

Hi Guys,

I have a table in SQL with reportname and email. In Flow through a storedprocedure I send a mail to the recipients with the reports which is belongs to.

For example I have a user1 and he has to recieve a mail 3 reports in this case he gets 3 mails. But how can I achieve that he only get 1 mail with all the reports.

Thanks in advance!

Categories:

General topics

Hi @Anonymous

You can do that by creating an array and collect all the content in that array and then pass it to the attachments. Please see the screenshot below:

Here, I have done that for the sharepoint part, you can replicate for the blob. First initialise an empty array variable at the top and then in the appen array variable use the file name with extesnion for the name and then binary(blob content) expression for the "ContentBytes".

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!