I have created 4 lists (Pillar1, Pillar2, Pillar3, Pillar4), each one with same type of fields. Entries in each list are recreated in a master list (Transfers). Each entry in one of these lists has two unique fields, the ID field and the Grouping field (list one has Group1, list two has Group2, etc). The ID field in each list is reflected in the Transfer list in column ForeignID while the Grouping column is listed as Grouping. Also a hidden field named Tranfer Status by default should be "Pending".

An entry in a Pillar is recreated in the Transfers list only if there are no other entry by the same user (CreatedBy) with Transfer Status "Pending".If an item by the same CreatedBy already exists with status "Pending" then do not create item in Transfers List and change the item status in the Pillar from "Pending" to "System Rejected".

Create Item workflow

This is working fine.

Now I need to update the Transfer Status of an entry in the Transfers List from Pending to Accepted or Rejected and this should reflect in the Original Pillar list it was created in.

Following workflow did this job

enter image description here

Unfortunately this workflow only updates list "Pillar1".

I want to make the workflow to first check the column grouping and if it is Pillar1 then update list Pillar1 with unique ID , if Pillar 2 etc. This must be in combination with the Foreign Key in the Transfers List which is not unique in this list. The Foreign Key becomes unique in combination with the field Grouping.

Following example:

enter image description here

  • too complex solution, just find any advace SharePoint consutlant to help with it. You'll probably will pay something... – Zdeněk Vinduška Feb 13 at 12:38

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.