Workflow To Assign Item From Another List

  • 27 October 2017
  • 2 replies
  • 1 view

Badge

I am working on a form where an end user can request a promo code.  The promo codes are generated by the vendor and given to us, so I was hoping I could have them in a separate list, then have a workflow that pulls the next available one and assigns it to the new request once the form has been submitted.  Is there a way using list lookups to make this happen?  Thanks!


2 replies

Badge +7

Hi, 

1-   Flag the promo code items (Add a "flag" field to promo code lists and set it to 0 by default).

2-   Request form will pull the promo code item where "flag" field is equal to "0" by using a calculated value control:

Lookup("Promo Code List","flag","0","promo code")

3- Once form is submitted, the workflow will do the below:

   A- Update all the promo code fields where "flag" is equal to "0" and set "flag" to "1".

   B- Generate the new promo code item ("flag" is equal to "0").

4- The next form will pull the last generated promo code.

Userlevel 5
Badge +14

within workflow you can use in-place lookup of several actions, even eg. update item action

210164_pastedImage_1.png

if conditions to identify suitable promo code from the other list a more complex you will need to use query list action to get the code.

Reply