cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meshare
Helper I
Helper I

Read excel and perform calculation

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 .

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Hardesh15
Super User
Super User

@Meshare 

 

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

 

13.jpg

 

Thanks

Hardesh

 

View solution in original post

4 REPLIES 4
Hardesh15
Super User
Super User

@Meshare 

 

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

 

13.jpg

 

Thanks

Hardesh

 

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.

 

 

@Meshare 

 

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

 

Thanks

Hardesh

@Hardesh15 

Thanks again.

Will try this today and update the results.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,432)