I have a SharePoint list that captures employee details and the error types they have committed. In the same list, I would like a column to auto-capture the number of instances of each error type when we select from the error type column.
Emp ID: 123 error type : err1 Instance :1
Emp ID :234 error type : err1 Instance 1
Emp ID: 123 error type : err1 Instance :2
Emp ID :234 error type : err2 Instance 1
How could I achieve this using flow / power automate?