I have a custom build list to store status updates on a project. To add a new item, one simply click + NEW ITEM, fils in the Infopath 2013 form and clicks SAVE. Then a workflow is triggered to convert some of the inputs. One of the list column (named LATEST) is a YES/NO column to show which status update is the latest update (so all should show NO except for the latest added update). In the workflow triggered by the + NEW ITEM submit one step is to lookup the current item in the list for which LATEST = YES and update for that item LATEST to NO. Then the next step is to set LATEST to YES for the Current Item.

However, the current item with LATEST = YES is not updated. (the new Item also shows LATEST = YES). So I end up with a status list full of Latest updates, while I should only have 1.

During the making of the Workflow I constantly get the warning that the lookup is not unique and that when more than 1 result is found that only the first will be used. However, in my case NONE of the items are updated!

So I have to questions: 1) How should I setup the UPDATE LIST ITEM action so that the current item for which LATEST = YES is updated to LATEST = NO. 2) Why is it not possible to update multiple items in one list based on a workflow. In my case I should only have 1 LATEST = YES item, so it is not critical when the lookup would work, but I can think of many cases where a new item triggers updates in multiple other items.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.