SharePoint Lists - Value from second list while adding a new entry
I’m trying to build a solution that employees can add a new entry to SharePoint List, when they plan to be available in office (because of COVID). The list is available in calendar view.
Normally all employees got their permanent office room. This information is stored in a second list.
We want to have an overview who is when available in which room. That is why we want while entering a new entry to first list, that the room is prefilled with their standard room, but still changeable (e.g. in case of to many colleagues at the same time).
Do you have any idea how to handle this with 2 SharePoint Lists?