Unanswered

Read excel list attachment and perform calculation

(0) Share

Report

Posted on by Meshare

Hi Folks,

I am fetching excel attachment from a source SharePoint list item and putting it in document library using power automate.

Now I want to read the same excel file and perform the calculation on it's column cells mainly addition /substraction based on some condition and want to update destination SP list's columns with these calculated value along with Souce item id.

Please suggest how can I achieve this.

Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Meshare

I'd like to help but I need a little more info.

So, I assume that the worksheet has multiple rows of data. Do you want to do something like sum the rows and then do a calculation on the sum? More info on exactly what you want to do will be helpful.

Also, my understanding is that you have a list item with an Excel attachment. You want to copy the attachment to a library and then update columns in the list. Is this correct?

Do you have a column in the list for the ID of the document in the document library?

Was this reply helpful? Yes No
Meshare on at

Like (0)

Report
Copy link

Link copied!

Hi @ScottShearer
Let me elaborate you the requirement.
I want to perform calculation on excel cell values not on total row's sum.
These calculated values I want to update in a new SharePoint list' columns.
Document library is just for keeping the attachment and for a reference to get the rows of excel.
In new SharePoint list we have parent id column which will should be updated with source list item id for reference.
I hope I am clear now.

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Meshare

Does your worksheet have more than 1 row? If so, what is your criteria for selecting the row containing the cells that you want to reference ?

Was this reply helpful? Yes No
Meshare on at

Like (0)

Report
Copy link

Link copied!

Hi @ScottShearer
Yes the sheet is having more than 1 row.
I want to filter rows based on some column values in same excel sheet and then perform addition and substraction on cell values.

Was this reply helpful? Yes No