SharePoint List to Look Up values in SharePoint Calendar

[Terri Sepulveda]

I have a SharePoint Calendar for employees to fill in availability (Like if they are out for vacation, doctors appointments, etc.).  I have another list of Employees available for assignment to jobs.  I would like to know the best way to have the Employees List look at the calendar and if they are not available during a specific time/date(s), then they are filtered from the drop down list of employees.  I have not worked with calendars before and really don't know where to start this.  I am using SharePoint Online with modern views and PowerApps as my forms.

[#2 · Accepted solution]

This kind of scenario is not supported by out of the box lookup columns so you have to implement this , as you have describe it, in PowrApps

[#3]

Then please explain how that would be done in PowerApps...…..