Read excel and perform calculation

[Meshare]

Hi Folks, 

I want to read an excel file uploaded in SharePoint document library and want to perform some calculation on it's column values. For example excel column A having 5 records (300,400,500,600 and 700) and power automate should add these all 5 values and update this value to a SharePoint list column.

Please suggest .

[Hardesh15 · Accepted solution]

@Meshare 

pls use below steps to calculate total of your excel column. later you can add condition and update SharePoint list value.

Thanks

Hardesh

[Meshare]

Thanks @Hardesh15 ,

Thanks for your response.

Could you please explain how you are adding the column values and  in which step you are performing this.

[Hardesh15]

@Meshare 

In apply to each loop i used increment variable action which is adding one by one value in variable total.

Thanks

Hardesh

[Meshare]

@Hardesh15 

Thanks again.

Will try this today and update the results.