Answered

Creating room booking with lists and power automate

(0) Share

Report

Posted on by Power_Automater

351

I have a SharePoint list in which when an item column is changed it will create and send an Outlook event. I have all of the other event details ready, but I am not quite sure how I can create a column with the rooms from Outlook for a user to select? I can see that there are 3 relevant actions in Power Automate: Get rooms, Get room list & Get rooms in room list.

How would I go about creating this in the List so the the flow can take the room from the column and add it into the event created in the flow? Do I need to use a special type of column/field in lists or is it in power automate?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

David- 1,254 on at

Like (0)

Report
Copy link

Link copied!

I am still developing something similar, but I am using a Switch action to handle this. The form contains a choice field with the options allowed, and this value is passed to the Switch:
Then the same setup is used in each switch for each of the calendars.

You could also put the e-mail address of each room as the choice and then you should be able to use that when you create the event in Outlook.

Was this reply helpful? Yes No
Power_Automater 351 on at

Like (0)

Report
Copy link

Link copied!

Hi @David- sorry my question was more around how to create the choice field with the rooms in it as options. Since there is a long list of rooms and the naming etc may change from time to time I was hoping to have some kind of dynamic way to have this choice field created eg. via a lookup field or by populating via power automate. Would you have any suggestions on that?

Was this reply helpful? Yes No
Verified answer

Power_Automater 351 on at

Like (0)

Report
Copy link

Link copied!

I've managed to do this with a lookup field, by creating a secondary list which is populated with the latest room list via a flow.

Was this reply helpful? Yes No