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 .
Solved! Go to Solution.
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.
In apply to each loop i used increment variable action which is adding one by one value in variable total.