workflow to populate a column based on 2 conditions

Hi @rutica,

this should be pretty straightforward.

You basically have 3 options:

1. Update your project when it gets changed (List Workflow on list Projects)
2. Update all projects when a risk gets changed (List Workflow on list Risks)
3. Have a workflow running on cycles and update all projects (Site Workflow)

2 and 3 can be realised as follows:

List Settings: In Risks go to List Settings and add the ID column to ImpactedProjects
Workflow:

1. Insert a Query List action and retrieve the IDs of all projects (no filter) in col_ProjectIDs
2. Inser a ForEach Action: Collection: col_ProjectIDs Store result in: tmp_str_Id
   
   1. Insert a query List Action (Please note: in tmp_str_ID there now is the list item id of a project)
      List: Risks
      Filter: ImpactedProjects:ID equals tmp_str_ID AND RiskClosed == "No"
      Field: RiskTitle -> col_RiskNames
   2. Insert some build string magic to make it look better if needed
   3. Insert an update Item action
      Update: Projects
      Where: ID equals Workflowvariable: tmp_str_Id
      Field: RiskInfo <- col_RiskNames (or the beautified value from (2))

Hi @Tarf 

Please forgive me for not replying sooner! I am truly sorry.

I tried your instructions above and it works perfectly. You are very smart! I would have never been able to figure this out but your instructions were clear and clever and I'm smiling ear to ear.

I'm usually a bit scared of workflows since I haven't used them very often and I usually run into problems when I try, but thanks to you, my fears are easing. :-) 

Thanks again!