0

I'm relatively new to all this, so I apologize if this is simply not possible or incredibly easy.

I have two lists, the first is 'Projects' which is a list of various projects being worked on, and another list is 'Clients' which is a list of clients I have. One of the 'Projects' columns is a Lookup from 'Clients', to define which client the project is for.

Within the 'Client' list is another column called Pipeline, with a "yes" or "No" choice. I want the 'Pipeline' column to update based on whether there are any projects being worked on in the 'Projects' list.

To add a level of complication, once a project has been completed in the 'Projects' list it is not removed, but the 'Status' column is set to from "✕" to "✓". I only want the 'Pipeline' column in 'Clients' to show that there are projects if they are "✕" ie. not complete.

Here is what the 'Projects' List looks like: Project List Example

Here is what the 'Client' List looks like: Client List Example

Please let me know if this is possible!

Many thanks,

Nathan

  • Workflow is going to be your first line of defense- what version of SharePoint are you running, and what version of the workflow engine? – willman Mar 1 at 3:21
0

you can use MS flow/ SharePoint Designer 2013 workflow

  1. use send http request to SharePoint list action for Project list
  2. In for each loop check if there is any incomplete project if yes
  3. get Current item client id send another request using filter and update Client list pipeline column .
| improve this answer | |
0

Depending on your environment, SharePoint Designer Workflow and MS flow(Power Automate) are both proper options.

If you are going to use Workflow, it may be better to make the workflow be triggered when there are items created/modified. Loop through all list items and check if there are projects belong to the client of current item still in "working on" status. Update the pipeline column in client list according to the loop check.

| improve this answer | |

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.