InfoPath Dev

Hi, Any ideas on how I can achieve this with a workflow or another way? I have repeating data in a form and I want to update the stock levels in the secondary list in SharePoint. ProductInStock list Product Price Qty In Stock Qty Required Product X 19.99 5 1 Product Y 18.99 3 2 When the form is submitted I want the Qty In Stock to become Qty In Stock - Qty Required. Can this be done with a workflow ? Appreciate any help here !

Hi Marculos and thanks for posting!

To extract data from a repeating section, you will need to map it to a list. A standard ShP 2010/2013 workflow cannot extract repeating data from an InfoPath form.

There are two ways to map the repeating data to a list. You can use CAML or qRules (common code library).

You'll want to do this from the form when it is submitted via rules on a button. Make sure to do this before the final submit. If the list mapping fails, you don't want to submit the form.

Please search for "repeating data CAML" or "repeating data qRules". There are many posts.

To do the calculation, you may need to either a) read it into the form and update it vi a separate list, or b) use a calculated value in the first list (not sure this is possible).

Good luck and let us know if we can help you.

Regards,

Patrick