I have a flow that gets data by looping through an array of elements and querying them against a Power BI report and creates 4 .csv files which are then saved to One Drive. This works fine. In the same for loop I have an Append to array variable step,
This is then used in Send an Email V2 step,
It successfully sends an email with 4 different .csv files which are named correctly however do not contain the csv table - they only show the Byte size of the file in cell A1. The examples I have seen online only seem to be using Sharepoint List in the Get Attachement Content step,
https://powerautomate.microsoft.com/en-us/blog/multiple-attachments-single-email/
I'm sure I am missing a simple step - any thoughts?