We have an employee table that has over 1,000 records. Many of the people no longer work here but we still need a list of them to be captured in our flow for historical reporting purposes. My first action is called "When an item is modified in SQL Server" where I link to the employee table. My next step is to get user profile (v2) where I capture the Office 365 id by linking it to the email address column in our employee table. Since many people left 1-5 years ago, they have no office 365 email/id and the flow fails for them. I get a status 404 error listed below.
"message": "User not found",
The flow still captures all active employees but I would like to create some sort of error handling that will simply allow all past employees with no Office 365 id to be sent to my spreadsheet anyway. I was looking at conditional logic but can't seem to figure this out. Any thoughts?