locked
How Do I update Multiple items in one list from 1 item in one list? RRS feed

  • Question

  • I have a list of that holds quotes.

    In the Quote list there will be a Part Number listed 1 time and a ext. price listed.

    the other List is Consumables list I have the corresponding Part Number and an empty ext. price  ( this can happen multiple times), as the items can be used for multiple items.

    I want to have the Quote List Part Number column and ext. price update the related Part Number and ext. price items in the Consumables list.

    Quote List
    Part Number Ext. Price
    TRA                25.99


    Consumables List
    Part Number    EXT Price
    TRA
    TRA
    TRA
    TRA
    TRA


    When the workflow runs I want the Results to be :

    Consumables List
    Printer   Part Number    EXT Price
    Printer1   TRA                 25.99
    Printer2   TRA                 25.99
    Printer3   TRA                 25.99
    Printer4   TRA                 25.99
    Pritner5   TRA                 25.99

    I realize I need a looping workflow, but my current workflow is not working.

    Any ideas on how to do this?


    • Edited by cowboy2066 Wednesday, July 11, 2018 7:51 PM
    Wednesday, July 11, 2018 5:55 PM