cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Adding Numbers in Excel

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?

5 REPLIES 5
alrez
Community Support
Community Support

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.

Anonymous
Not applicable

How do you initialize the variable

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.

 

Untitled.png

Anonymous
Not applicable

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

 

Anonymous
Not applicable

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,277)