You’re offline. This is a read only version of the page.
343
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?
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.
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?
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.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
