I can't for the life of me figure out how to accomplish this and it seems it should be something simple. I have a SharePoint list of entries from users. I have another SharePoint list that I create with a flow to just pull in active employee's and a column with their Display Names.
The goal is to show on my report details by employee's where I have a count of the number of submissions they put in with a date filter but also include all the employee's that have not submitted.
So the idea is to add a 0 count for all the "Missing" employee's.
I found an article that worked for and gave me a list of all missing entries using the except? funciton. However, this doesn't respect when you apply a date filter to the report page and is just a list of missing "all time"
Anyway, don't need exact how to, but if someone has an overall idea how to accomplish this that would be great. Ideally I'd like those users to show in the main count list with 0's, but if it has to be a seperate graphic to make it easier that is fine, but it always need to respect the current date range of the primary data table then search for missing employee's that exist in the active employee table.
Hope this makes sense! Thank you for the ideas!
