Hello,
I want to create a flow that does the following steps:
1. Exports data from Power BI every month (My Power BI table has 4 columns: Sales No., Value, Date, E-mail)
2. Sends an email with the data exported to different people based on filters
The exported data should look something like this:
In this example, I would want to send an email to the two different emails represented in the column Email with only the data rows referring to its email.
Which means that, for example, when sending the email to name1.sm@gmail.com only the first 4 rows of the data should be sent on the attachment.
This behaviour should be replicated for each one of the different emails in the column Email.
I have accomplished the first step with the following flow:
However the file generated is in CSV with the values in only one column and delimited by commas.
Like this:
So, from this I am not sure how I should proceed.
Can you help me?
Thanks