Unanswered

Adding Numbers in Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

How do I create a flow that will increase the amount of items issued for an inventory in an excell spreadsheet. I.E. Equipment issued is at 2 a list item is added in share point that tells the spreadsheet to issue one more item to a person. How do I tell excel to increase the integer in the cell from 1 to 2?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

alrezac Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

The general idea of the flow is first you would like it to trigger off of something. For now we will just make in manual. Second we need to grab the specific item from you Excel document. So the Excel document will need to be located somewhere that Flow can connect to and it needs to be formatted in a way that Flow can read the Excel document. They we just need to grab the row that contains the value. From there we need to initialize a variable to whatever value we are grabbing. Then we need to use the increment variable set to increase it by 1. And lastly we need to update the Excel row value to the new variable that we increased.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

How do you initialize the variable

Was this reply helpful? Yes No
alrezac Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is what you are looking for for the variable actions. You will need to set the variable to the value in your Excel document. then you will need to write to your Excel file using your variable.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I get an error message, "The inputs of workflow run action 'Set_variable_2' of type 'SetVariable' are not valid. Self reference is not supported when updating the value of variable 'Item'." when trying this. Thank you so much for the help so far

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Also Power automate doesn't seem to be reading previous flow's run.

Was this reply helpful? Yes No