Filter GetItems to Show Only Current Employees/People

Iron Contributor

I'm copying list items from one SharePoint list to another. 

The flow is failing because it cannot find information on users who've left the company. The message is 

The specified user i:0#.f|membership|EmployeeEmail could not be found.

 

I'd like for my Get Items to just skip over those it cannot find since I won't need them anyway. 

I've tried putting 'Employee/EMail ne null' in my Odata filter query but it continues to fail and return the count of all records to me.  I also tried a condition Employee/EMail eq ''.  Didn't like that either. 

Is there some way I can filter my list so it pulls only current employees.

Thank you.

1 Reply

@CindyZ unfortunately you need a few more steps to handle this. It is because the field is not empty in the list you are copying from. It is when you try to fill out the user in the column on the new list, that it gives an error. That is because a Person field triggers a validation of whether the user exists. So you need to either:

 

1. Paste it to a "Single line text field" to skip any validation of the input. However you loose a lot of functionality in doing so.

 

2. Add steps in your flow, to search for the user with the action "Search for users (V2)", check whether it returns anything and then create the new list either with or without the user info, depending on the result. See the answer to this post