Calculate total of CSV cell and populate SharePoint list every hour from received mail attachment

[Anonymous]

Hi all,

I have 2 emails that come into my inbox folder that have CSV attached and in that CSV, a cell that has a heading of "Test" and then 1 value per csv attachment, these emails come into my inbox every hour on the hour. 

For each pair of emails, I need to get that value cell, add them together and then populate a sharepoint list with the data

Date              Time            Count

20/04/2010   13:00           1045

20/04/2010   14:00           1700

20/04/2010   15:00           1845

20/04/2010   16:00           1900

20/04/2010   17:00           1500

Etc

I am trying to understand how to do this?

Thanks in advance.

Jon

[ChristianAbata]

hi @Anonymous  unfortunally you can't read the data inside csv file to manage it, becouse a requirement to read data is a table, and a table only could be created into a new format excel that is .xlsx files.

[Anonymous]

Ok thanks. So say the file is xlsx then can it be done ? If so how ?

Thanks.

[v-alzhan-msft]

Hi @Anonymous ,

If you sent the excel file as attachment, your requirement could be easier achieved.

Please refer to steps below:

1. Create table to the excel file as link below:

https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664

 Make sure the table Name would always be the same such as always be "Table1".

2. send the email with the excel file as attachment, the screenshot of the flow as below:

In the Table field of the list rows present in a table action, make sure that you would enter the custom table name "Table1".

Flow would run successfully as below:

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks. Where is the calculation done to add the two totals from each file together and where am I referencing that cell in each spreadsheet in the flow ?

[v-alzhan-msft]

Hi @Anonymous ,

The provided solution is to create items in the list from one excel table in the single flow.

If you would receive two flows and add value from the column in the two table,  you need to achieve it step by step.

Firstly, create items from table 1 to list 1, then create items from table 2 to list 2, finally, add the value in the list 1 with corresponding value in the list 2, then save the value.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Alice

Thanks for this, however, how am I am unable to populate the columns in the create item step ?

part 1

part 2

I also had to type in the 'Table1' value in the Table field in the 'List rows present in a table' step

[v-alzhan-msft · Accepted solution]

Hi @Anonymous ,

Sorry there is no any way in Microsoft flow could get the Table name and save the table name in the list currently, for the columns in the excel table, refer to screenshot below:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Ok thanks

So your value of Table1 is a custom value in that field in the step ?

I’m still unsure how I can populate the fields. From the spreadsheet to the Sharepoint list.

[v-alzhan-msft]

Hi @Anonymous ,

Could you please share the screenshot of the flow?

Have you add create item action inside the apply to each 2?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.