Answered

Help with action on Excel for inventory

(0) Share

Report

Posted on by RTProduction

Hello Community,

I'm currently trying to create a flow that counts inventory. The hiccup I'm coming across is my script can write to an excel cell. However I'm stump on how to add an existing value to a cell. Here is more clarification.

I have a Finished product that contains 5 piece's of components. When I scan the product number, I want it to add a value to a cell for the 5 individual part break down (comp1-comp5). I have a spreadsheet that contains the 5 component items for this product and my script will fil in all the components based on how many finished goods are on the shelf. When I scan this product, my flow will say how many of this product you have. My challenge is when I scan this product again it will just over ride the cell with this value when I need it to add together to the existing value in that cell. I think there is an action that says "check cell for existing value, if blank write the new value, if not blank then add the new value to the existing value.

I'm using this to manage inventory on how many pieces we have.

Nay help would be greatly appreciated. Thanks.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @RTProduction

May be this logic would help you ?

The flow will read a specific cell value and then uses if condition to check whether the value is empty or not, if value is not empty, it will assign the value let's say the component data which we need tp write to. Else it will append that component's data to existing cell value using set variable. Finally it writes the data in excel.

This is a basic flow and I hope this would help to clear all your doubts !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
RTAProduction 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your suggestion!
Unfortunately that isn't working for my script at the moment 😞

I have attached screenshots of what the flow currently looks like.
The main issue again is that we are trying to update a cell in Excel with the "User inputted" Number.
Currently my flow is set up to add your quantity(user inputted) to a designated spot in an excel spreadsheet.
That all works just fine.

The issue starts coming up when you try to inventory another said item with the same "Inventory Items"
(ie. the "NANO" in the first screenshot) - I had attempted to do a If/Else statement to see if that would work, Nothing.

Instead of it adding the user inputted number(completely custom based on quantity in warehouse), It just overwrites the number and only logs the "UserInput" number.

Is it not possible to add a custom number to an existing number in excel while using PA?Picture 1Picture 2

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Use first free row on column or row activity and give the variables to write to excel sheet
Firstfreerow-1
And firstfreecoloumn-1
It appends your input without overwriting

Hope this helps
Usha

Was this reply helpful? Yes No
Verified answer

RTAProduction 24 on at

Like
a
(2)

Report
Copy link

Link copied!

I was able to figure it out!
My flow was unsure on what formula I was using to calculate,
I found an article that was talking about variables specifically from Microsoft and this is what ended being my solution..

%ExcelData + UserInput%

Thank you to those who gave suggestions!
I appreciate you taking the time to help a stranger out!!!

Was this reply helpful? Yes No