0

I have 2 lists with the following columns:

  • List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)"
  • List B - "StatusNameReq"(Lookupcolumn based on the columns in List A)

Now, I want to filter the view of ListB based on "StatusNameReq". To be precise, I want it to show items in the view only if in the "StatusNameReq" are contained the words "COMPLETED", "ARCHIVED", "CANCELED".

So, first of all, I created a new column in ListB called "Archive Status" as a choice column, with the options: ARCHIVED, CANCELED, OPEN, COMPLETED, APPROVAL. Then, in SPD, I created a workflow that it's like this:

If StatusNameReq contains COMPLETED

Set Archive Status to COMPLETED enter image description here

And so on for the other ones. In the view of ListB I then applied the filters like explained above (meaning, based on Archive Status).

For some reason, it doesn't work. Can somebody help me out with this?

I'm using SPD 2010 Workflows with SP 2013 (free version).

  • can you add screenshot of your workflow? are there after run some error or the WF only didnt anything? – Zdeněk Vinduška Feb 11 at 21:37
  • And a screen shot of it...not working? It doesn't work is pretty much never helpful. What does it do? Do you see an error message? Does it show too many items? Too few? – Joe McShea Feb 11 at 22:18
  • Hi JoeMcShea, no error message, otherwise I would have uploaded it :) It just simply doesn't update my field "Archive Status", like nothing is happening... – Laura Feb 12 at 8:07
  • Hi Zdeněk, I've added it in my original post – Laura Feb 12 at 8:23

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.