Hello everyone,
What I am trying to succeed is when the item of a SP list is modified then the flow will update the item of another SP list.
I have two lists the Training list which has all the training sessions and a column named as TrainingStatus and a second list with all the registrations by training course where I also have the column ID of the first list and a column named as Event Status.
What I want to make is when the status column of the first SP list is modified then to update the column status of all the rows of the second list that have the same session ID. And finally send email notification to all the registered users that this training session has been cancelled
I created the following flow:
When an item of the 1st SP list is modified
Get items of the second SP list
Condition Control : if the ID of the first SP list is equal to the SessionID of the second list and if the Status of the first SP list is equal to Cancelled
Update item of the second SP list
I am sure that I am doing something completely wrong.
I appreciate any help/advice.
Many Thanks
Thank you for your response.
I am afraid this didn't work.
In Condition 3 is the SessionID of the Second list and the ID of the first List.
On the update item step, the Id and the title were coming from the trigger, as suggested, but the flow didn't run successfully. But when I replaced them using the fields Get items of the second list, the flow did run successfully.
However, because your reply did help me to find the solution, I marked it as solved.
Many Thanks
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1