Unanswered

Recurring email of sharepoint list with csv attachment

(0) Share

Report

Posted on by JB1911

Hi,

I have created a flow for recurring email based on this; How to export SharePoint List items to excel using Power Automate and send email [Step-by-step tutorial] - SPGuides

However, Automate automatically creates an apply to each over the flow after the recurrence action, which means that when testing I am getting 10+ emails through. Woudl anyone be able to advise how to get this into one CSV file for all info within the Sharepoint List.

Please see below images of the flow, I have deleted the sensitive information.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Have you tried creating the output file, capturing the link or ID of the file, then, outside of the apply to each loop, get file content and attaching it to the outbound email?

High level idea:
Flow triggered
Variable to hold output file ID
Get Items
Loop
... do stuff
Create File
Set Variable to the file ID
Get File Content - ID = Variable
Send email - attach file contents

Haven't tested it, and I'm not 100% sure if you need to move the Create File out of the loop. Doing the Create File in the loop would result in the file being overwritten X times?

Was this reply helpful? Yes No
JB1911 2 on at

Like (0)

Report

Hi,

Thanks for the response, will give this a try and feedback.

The overwriting wouldn't be an issue as it would just become the current update each time.

Thanks

Was this reply helpful? Yes No