Unanswered

Help with using a Flow to sum excel columns & send in email

(0) Share

Report

Posted on by Craig_Mc125

I'm pretty new to flows, especially using expressions etc.

I think the premise of what I am trying to do is acheivable & am just hoping someone can give me some guidance on how to do the last part.

Essentially, what I'm trying to do is the following:

I have muliple spreadsheets that I will drop into a sharepoint drive (Trigger When a file is created in a folder Sharepoint)
It will have a different file name each time.
The information in the spreadsheet will always presented with same columns & organised as 'Table1'.
I then need to send an email to a user, which sums the following columns that are in the table AR, DM, BS, BU, BW, AV & AW.
I have used the List rows present in a table couldn't see Get Rows (might be as it's SharePoint based?).
I have then used Compose with an expressions sum(body('List_rows_present_in_a_table')?['value']?[AR'])
I need to then use the output from the sums populated in the email, if that's possible?
I then need to attach the document to the email, which it is succesfully doing, but it doesn't retain the original file name (whch actually is important sadly).

Below is a snip of what I've done, it's the compose bit that i'm struggling with & how to put the specific outputs into the body of the email.
If someone could give me any pearls of wisdom i'd appreciate it.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-mingkz-msft Microsoft Employee on at

Like (1)

Report
Hi @Craig_Mc125,
Do you want to get excel from SharePoint Library, and get summary of columns value?
Do you want to send the file as attachment to email?

I did some test according to your requirements.

Following is my flow.

items('Apply_to_each')['number']

Best Regards,
Kyrie

Was this reply helpful? Yes No
Craig_Mc125 2 on at

Like (0)

Report

Hi

Thanks for the below, I really appreciate your efforts in responding - in answer your questions:
Do you want to get excel from SharePoint Library, and get summary of columns value? I will be dropping the file into the drive as the trigger. Yes I need to total the folowing columns of the Table in the spreadsheet AR, DM, BS, BU, BW, AV & AW. All separetely if possible, as i need to break out those totals for each (per my email screenshot above).

Do you want to send the file as attachment to email? Yes, I want to attach the file from the sharepoint to the email.

Does that explain? I assume that might mean some changes to the above?

Thanks, appreciate the help.

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like (0)

Report

Hi @Craig_Mc125,
I think the previous solution is effective. You just need to initialize more variable to record the sum of columns in Excel table.

Was this reply helpful? Yes No