You’re offline. This is a read only version of the page.
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?
Also Power automate doesn't seem to be reading previous flow's run.
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
How do you initialize the variable
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.
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
