Send if rows present in CSV and create table

[Tristan_C]

Hi,

First time posting, new to PA. Would love some help.

I am exporting a csv from Power BI. I have that part sorted, but now I need to do 2 things:

1. Evaluate the csv for an email send. If there are rows in the table (sometimes there won't be) then I need to send an email.

2. If there are rows then send the email and ideally embed the csv as a table.

Thanks

[ManishSolanki]

Hi @Tristan_C 

We can check the length of CSV table to conclude if its empty or not. In the below sample snippet, I have split the CSV string by newline and then check the length of array to find out if its empty or not.

Here is the condition part of the flow:

You need to write the below expression for the left side operand in the expression window:

length(split(body('Create_CSV_table'),decodeUriComponent('%0A')))

If condition is "Yes" or true, then send an email and if false then create a file in onedrive:

In the 'File Content' parameter, pass the output of 'Create CSV table' action as shown below:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[Tristan_C]

Thank you @ManishSolanki - this is a great start.

So I have decisioned the process to count the rows thanks to your code, the second part still has me blocked on this.

- If the csv has content then I need to send the csv in an email. Ideally I would like to embed this in the email as an image/table if possible so the recipient can see the content.

- If the csv has no content then terminate

Appreciate your help.

[ManishSolanki]

Hi @Tristan_C 

In my previous reply, I had provided solution to save the file in one drive if csv table has data 🙂

Here are the steps for the second part of the problem:

After checking the length and if found to be empty, then we will terminate the flow in the "Yes" part as shown below. In 'Terminate' action you can select 'Succeeded/Cancelled/Failed' as per your need:

In "No" path, we will send an email to the user and share the output of csv as an attachment:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[Tristan_C]

Thank you, making progress.

So as the final step, rather than attaching the file, I want an embeded an HTML table in the body of the email of the results. I seem to able to create the table but the formatting is terrible, I think i am supposed to use "Compose" to get this right but I doenst seem to be making any difference to the HTML table created.