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
