Email Reminders with Conditional Statements and Lookup to 2 SharePoint lists

[hexarthrius]

Hey there,

I'd like to create a Flow with email reminders that checks if an employee has already added a record in an app I made. The data source is SharePoint list and there are two lists:

• Employees (list of all users who are using the app and tp specify some custom columns)
• App Data (Where we need to check if the employee has submitted a record here)

The flow is done on a per daily basis (excluding email), and the flow should check if the user has already submitted a record for that day. If it already has a record for that day, no email should be sent. Otherwise, send a reminder email.

I already got the first parts working which is the checking per day:

But I'm not sure how to check SharePoint lists together so that for every employee that I have in the Employee list, I need to check if he added a record there. I'm thinking to use the Created By Email so that I can check that with the Employee Email. I did that here:

And after that, I did this:

What I'm doing for now is trying out to filter that for each employee, I can filter the workday data to check the Created By Email if it's equal to the Employee's Email. I'm having trouble with the following:

• Checking if the Filter can accommodate to have dates created today (not DateTime, just the date)
• The data ouput there in my filter doesn't return anything, even if I do have an Employee Email and a record in the Data which is the same employee:
  
  SharePoint list for Data contains this:
  For Employee:
  

Any help with those concerns are appreciated. 

Thank you!

[manuelstgomes]

Hi @hexarthrius 

Sorry, there's one point I don't understand. You're comparing the employee name with the email?

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Cheers

Manuel

[hexarthrius]

Hi @manuelstgomes,

The Employee Name  is a Person datatype so I used the Employee Name Email to compare it to Created By Email. In the filter array, it will read as Created By Email is equal to Employee Name Email so I'm comparing emails