cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Multiple items lookup in workflow

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

Labels: (2)
Tags (3)
0 Kudos
Reply
3 Replies
Highlighted
Not applicable

Re: Multiple items lookup in workflow

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.

 

Jesper

0 Kudos
Reply
Highlighted
Not applicable

Re: Multiple items lookup in workflow

Dear Jesper,  Thank you for your feedback.  Please mark your question as answered so others can see and ask more questions if required.  Kind Regards, Support

0 Kudos
Reply
Highlighted
Not applicable

Re: Multiple items lookup in workflow

Awesome! Thanks for letting us know how you solved it

0 Kudos
Reply