Hello,
I have a new challenge. I want to build an inventory app via PowerAPPS based on Sharepoint lists.
I did created the sharepoint list with name Inventory with some basic column data like:
name, description, manufacturer, part image, serial number, stock, reorder stock threshold.
Now i want this list to be updated via a 2nd list, named asset_movement (in this list i want to keep track of all incoming products to stock/inventory).
This list contains: name, description, manufacturer, serial number, date received, stock received.
I want to link both lists based on serial number since is unique and is linked to a certain product, and i want to update in List A the column with stock by adding the values form the 2nd list on stock received.
Did it make sense to you?
Using integrated Lookup function in sharepoint column didn't do the trick, and in MS Flow i am stuck.
Anyone has a better idea?
Thank you.