I have a list of orders and I need to calculate the total price from each order.
The order items are a lookup from another list(Items) containing the item price itself. On my order list I would like to create a workflow which based on the multiple items in the order(these being placed in a multichoise single line text field) loops through each item , collects the price from the lookup list(Items) and add it to the total. Can this be done within a workflow or do I have to redo my orderlist be based on a repeating section instead of a multivalue column?
Thanks Jesper Bergmann
I solved the problem myself.
By using regular expression to extract the Items names from the multi item field I could then loop though the Collection in which I placed them and for each loop look up their price in the Item list, calculate the total and publish this to the total order field in my Order list.
Please feel free to ask if you run into a simular challenge.