Dynamic Dropdown Based on Dates

[Nagesh_Raghav]

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.

[Suvrutt_Gurjar · 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.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Nagesh_Raghav]

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

[Suvrutt_Gurjar]

Correct.