I have a gallery that is a shopping cart of items selected with quantity and unit price for each item. The quantity and unit price for each item is saved (patched) to the SharePoint list EquipmentOrders. The total price will be saved (patched) to SharePoint list Orders. I am not using collections. I am just using patch functions.
What's the best way to calculate the total price? I need to set a calculated total price in a field named Total Price on the screen. Do I use the LookUp function to calculate it from the saved data in Equipment Orders from the Unit Price and Quantity based on a particular Order ID? Do I reference the gallery items? How do I select all the items per order to do the calculation? Do I need to set up a temporary collection?
Many thanks!
