Conditional Formatting in sharepoint list

Question

I have created a meeting request form in a sharepoint list, and users have an option to select one of our meeting rooms. I am trying to achieve the following: When the user selects a meeting room, it would bring up the meeting room calendar and give them an opportunity to see if the room is available for their desired time and date. I have ownership rights for the meeting room calendars, which are actually full accounts.

I have several flows associated with this list, with one of them creating a calendar event in the meeting room for the selected date and time, but it currently has no way to verify if there is a conflict.
There are certainly many ways to go about this, so if you have another way of addressing this, or a possible solution, it would be greatly appreciated.

Answer 1

@Ki Bang

In the SharePoint meeting request list, you could use lookup column to select meeting room.

After you select meeting room, you could click the value to check the meeting room calendar event.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.