locked
How delete old item in a list and insert a new record instead with the updated data in SharePoint Designer? RRS feed

  • Question

  • Hi,

    I need to create a workflow in SharePoint Designer 2010 that will delete list items and update the records with new data.

    When a new item is created the workflow will be triggered to check if the list already have a record with the same column (Contractor) value , if the new contractor doesn't exist in the list the workflow need to create the record as normal.

    If the new contractor is already in the list, the workflow needs to do a calculation (add 1 to their current Rank(column)).

    My intention is to create a list of 5 contractors with rotation (ranking 1 then go to 2, ranking 2 then go to 3 ..... if ranking 5 then go to 1) 

    The issue I am having is that every time I try to access a value in the workflow, I get a message that says "can't return a single value, will take the first one" something like that.

    Can anyone give the steps to do this?

    Thanks.

    Wednesday, March 19, 2014 3:48 PM

Answers

  • hi Chicho84,

    What value are you trying to access?

    Regards

    P

    • Marked as answer by Andy__G Wednesday, January 7, 2015 10:35 PM
    Wednesday, March 19, 2014 4:58 PM

All replies

  • hi Chicho84,

    What value are you trying to access?

    Regards

    P

    • Marked as answer by Andy__G Wednesday, January 7, 2015 10:35 PM
    Wednesday, March 19, 2014 4:58 PM
  • The previous Contractor's value. 

    For example: If contractor ABC is already in the list then can't be recreated by rather the rank updated.

    Thanks. 

    Wednesday, March 19, 2014 5:12 PM