Hi All,
Hoping someone can help me here.
I have an order form that end users complete to request certain equipment from our stores section.
Once the user has submitted the order form, it creates a task which gets sent to an iPad in our stores section for our staff to pick and send off.
The order form consists of a repeating section that has two lookup fields in it, looking up data from a sharepoint list with the catalogue items. The two lookup fields are named "Category" and "Item".
One of the biggest complains I am getting from the stores workers is that when they are picking, they are going back on themselves multiple times as the items in the picking form aren't in the order of the category.
Is there a way, with a Nintex Workflow, that I would be able to query each of the lines in the repeating section, look for the Category, and order the lines in the repeating sections by the Category?
Please see below an example of what I mean:
Order form submitted with 4 items:
1x Category="Fuel" - Item="AdBlue 500ml"
1x Category="Stationary" - Item="Pencils"
1x Category="Stationary" - Item="Pens"
1x Category="Fuel" - Item="AdBlue 1L"
In the workflow, query XML and reorder the lines on Category, so the output and the picking task is ordered like:
1x Category="Fuel" - Item="AdBlue 500ml"
1x Category="Fuel" - Item="AdBlue 1L"
1x Category="Stationary" - Item="Pencils"
1x Category="Stationary" - Item="Pens"
I appreciate any replies and/or help given.
Thanks,
Conrad
