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)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@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

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,270 Most Valuable Professional on at

Like (0)

Report

@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

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