Help getting the list of rooms in a roomlist

Like (0) Share

Report

Posted on 13 Oct 2019 03:28:28 by lvdp

I need to display the list of rooms on a floor in a datatable for the currently selected room list.

I can display the list of room lists easily enough:

ClearCollect(Floors, Office365Outlook.GetRoomListsV2().value);
Created a droplist with Items = RoomLists.name

What I'm having trouble with is display the actual room names in a datatable when a given floor is selected. I've tried the following:

In the dropdown I have:
OnChange=ClearCollect(RoomsOnFloor, Office365.GetRoomsInRoomListV2(FloorDropDown.SelectedText.name).value); Which generates an error when the droplist selection changes.

In the data Table (RoomsOnFloor) I have also tried:

Filter(RoomsOnFloor, Office365.GetRoomsInRoomListV2(Dropdown1.Selected.name).value)

Neither of which work for me. Any suggestions would be welcome - I've spent days trying to figure this out!

Categories:

Connecting to Data

droplistchangeerr...

All responses (4)

Answers (0)

McPowerPlatform 38 on 10 Nov 2023 at 17:29:53

Like (0)

Report

Help getting the list of rooms in a roomlist

I've solved this with two Collections,
First :
ClearCollect(testLocations,Office365Outlook.GetRoomListsV2().value);

Then a New Collection:
ClearCollect(RoomsOnlocation,
Ungroup(
ForAll(testLocations As Loc,
Office365Outlook.GetRoomsInRoomListV2(Loc.address).value

)
,"Value")
😞

let me know how this works for you
McPowerPlatform 38 on 27 Jan 2023 at 14:54:49

Like (1)

Report

Re: Help getting the list of rooms in a roomlist

I've solved this with two Collections,
First :
ClearCollect(testLocations,Office365Outlook.GetRoomListsV2().value);

Then a New Collection:
ClearCollect(RoomsOnlocation,
Ungroup(
ForAll(testLocations As Loc,
Office365Outlook.GetRoomsInRoomListV2(Loc.address).value

)
,"Value")
😞

let me know how this works for you
lvdp 11 on 15 Oct 2019 at 04:34:18

Like (0)

Report

Re: Help getting the list of rooms in a roomlist

So....
My On Start funtion is now :
ClearCollect(Floors, Office365Outlook.GetRoomListsV2().value);
ClearCollect(RoomsOnFloor, Office365Outlook.GetRoomsInRoomListV2("room list 1").value.name)

This givens me the Floors collection just fine, but lists nothing for the rooms on floor collection and it doesn't throw an error either.
I have also tried just using
Filter(RoomsOnFloor.name, Dropdown1.SelectedText.name) where Dropdown1 is the floor list still no luck.

Any more ideas?
v-monli-msft on 14 Oct 2019 at 08:46:07

Like (0)

Report

Re: Help getting the list of rooms in a roomlist

Hi @lvdp ,

Please try to add ".name" after ".value".

https://docs.microsoft.com/en-us/connectors/office365/#get-room-lists-(v2)

Regards,

Mona