Showing results for 
Search instead for 
Did you mean: 
New Member

SharePoint Lists - Value from second list while adding a new entry

Dear community,


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?


Thanks in advance!







Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,441)