I have 2 SharePoint lists both with the column EID.
All Members contains all the group members:
EID |
dummy.name1 |
dummy.name2 |
dummy.name3 |
Attendance Tracker contains a list of group members who has logged their attendance for [Today]:
EID | DateLogged |
dummy.name2 | 4/22/2022 |
Below is my current flow:
I think my filter is wrong as I didn't get the member's who haven't logged their attendance. After filtering the All Members list, I would like to send an email for those who is not present on the Attendance Tracker.
How do I achieve this?