Dynamic Dropdown Based on Dates

I am making an attendance App, I want to remove the names of the person whoโ€™s attendance has been done and I did that by (List of Employees[Emp Name] - Attendance[Emp Name]). When the date changes it still remove the names(Previous Date) which are present in Attendance Table.

Is there any way where the dropdown changes daily, where it checks whether the name is present in the table for today and if the name is there for todayโ€™s date then it removes the name from the dropdown for that date.

Solved Solved
0 3 209
1 ACCEPTED SOLUTION

I believe, you will need to use the SELECT() statement on the second part of the expression to qualify the employee attendance list for todayโ€™s date.

View solution in original post

3 REPLIES 3

I believe, you will need to use the SELECT() statement on the second part of the expression to qualify the employee attendance list for todayโ€™s date.

Do you mean like this
List of Employees[Emp Name] - SELECT(Attendance[Emp Name], [Date]=TODAY(), true)

Correct.

Top Labels in this Space