Issues with to lists and the use of calculated columns

%3CLINGO-SUB%20id%3D%22lingo-sub-695851%22%20slang%3D%22en-US%22%3EIssues%20with%20to%20lists%20and%20the%20use%20of%20calculated%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695851%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%20I%20need%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20lists%2C%20Inventory%20and%20Orders.%3C%2FP%3E%3CP%3EThe%20%3CSTRONG%3Einventory%3C%2FSTRONG%3E%20is%20basically%20just%20product%20name%2C%20product%20number%2C%20amount%20and%20location.%26nbsp%3B%3CBR%20%2F%3EThe%20%3CSTRONG%3Eorder%3C%2FSTRONG%3E%20has%20customer%20name%2C%20customer%20number%2C%20a%20look-up%20field%20from%20%3CSTRONG%3Einventory%3C%2FSTRONG%3E%20to%20see%20the%20amount%20available%2C%20and%20a%20column%20for%20the%20amount%20needed%20from%20the%20customer.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EWhat%20I%20wish%20to%20do%2C%20is%20be%20able%20to%20update%20the%20%3CSTRONG%3Einventory%3C%2FSTRONG%3E%20amount%20field%20when%20a%20new%20order%20with%20the%20order%20amount%20field%20is%20added.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20google%20a%20bit%2C%20but%20not%20much%20relevant%20was%20found.%20I%20also%20tried%20to%20use%20powerapps%2C%20but%20couldnt%20find%20the%20right%20formula%2C%20and%20i%20tried%20to%20use%20flow%20to%20update%20the%20inventory%20amount%2C%20but%20cant%20find%20the%20right%20expression%20there%20either.%3CBR%20%2F%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-695851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-705488%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20to%20lists%20and%20the%20use%20of%20calculated%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-705488%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20help%20out%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-706149%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20to%20lists%20and%20the%20use%20of%20calculated%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-706149%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361441%22%20target%3D%22_blank%22%3E%40Holtklimpen%3C%2FA%3E%2C%3CBR%20%2F%3E%3CBR%20%2F%3Enot%20sure%20your%20looking%20for%20a%20calculated%20column%20or%20a%20addition%20column%20from%20your%20order%20list%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20need%20a%20order%20sum%20for%20a%20customer%20from%20your%20inventory%20list%20I%20recommend%20to%20use%20a%20automatic%20excel%20and%2For%20Power%20BI.%20After%20this%20you%20can%20filter%20by%20your%20customer%20name%2C%20customer%20number%2C%20etc.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20not%20sure%20if%20the%20total%20sum%20feature%20for%20columns%20in%20the%20modern%20view%20already%20supported.%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%3CBR%20%2F%3EJens%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-706760%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20to%20lists%20and%20the%20use%20of%20calculated%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-706760%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361441%22%20target%3D%22_blank%22%3E%40Holtklimpen%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20you%20can%20use%20Flow%2C%20then%20on%20the%20new%20order%20create%20event%20trigger%2C%20you%20can%20get%20related%20Inventory%20item%20(I%20suppose%20you%20have%20the%20lookup%20to%20the%20inventory%20in%20your%20order%20list%20item)%20and%20then%20update%20the%20remaining%20amount%20in%20the%20Inventory%20item%3A%20inventory_remaining_amount%3Dinventory_remaining_amount-ordered%20amount.%20If%20your%20orders%20can%20be%20edited%2C%20then%20the%20flow%20gets%20a%20bit%20complicated%20because%20you'll%20have%20to%20adjust%20remaining%20amount.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi guys, I need help.

 

I have two lists, Inventory and Orders.

The inventory is basically just product name, product number, amount and location. 
The order has customer name, customer number, a look-up field from inventory to see the amount available, and a column for the amount needed from the customer. 


What I wish to do, is be able to update the inventory amount field when a new order with the order amount field is added. 

 

I tried to google a bit, but not much relevant was found. I also tried to use powerapps, but couldnt find the right formula, and i tried to use flow to update the inventory amount, but cant find the right expression there either.
Can anyone help?

 

 

 

3 Replies
Highlighted

Can anyone help out?

Highlighted
Hi @Holtklimpen,

not sure your looking for a calculated column or a addition column from your order list?

If you need a order sum for a customer from your inventory list I recommend to use a automatic excel and/or Power BI. After this you can filter by your customer name, customer number, etc.

I'm not sure if the total sum feature for columns in the modern view already supported.

Regards
Jens
Highlighted

Hi @Holtklimpen

 

if you can use Flow, then on the new order create event trigger, you can get related Inventory item (I suppose you have the lookup to the inventory in your order list item) and then update the remaining amount in the Inventory item: inventory_remaining_amount=inventory_remaining_amount-ordered amount. If your orders can be edited, then the flow gets a bit complicated because you'll have to adjust remaining amount.