GetRoomsInRoomList - how to use

(3) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to run the following:

ClearCollect(AllRooms, Office365.GetRoomsInRoomList("1stfloormeetingroomright@gmail.com")

Where 1stfloormeetingroomright@gmail.com is a valid meeting room.

However, it returns no results.

ErrorResolutionNameNoResults.

No Results Found.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to Get rooms in room list?

If so, I suggest you not use GetRoomsInRoomList function.

This action has been deprecated. Please use Get rooms in room list (V2) instead.

Try this formula:

Office365Outlook.GetRoomsInRoomListV2(Room list address)

Also, since "1stfloormeetingroomright@gmail.com" is considered a valid meeting room list in your formula, I suggest you use Office365Outlook.GetRoomListsV2() function to check whether you have this room list address.

You could use this formula to get all the room lists value:

Office365Outlook.GetRoomListsV2().value

It will return a table with the data of all the room lists in your talent, with two fields: Address, Name.

You need to use one of the Address value of this table in your Office365Outlook.GetRoomsInRoomListV2() function.

Here's a doc about this connector for your reference:

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

Best regards,

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yutliu-msft ,

Thank you for the reply.
Unfortunately, we cannot use GetRoomLists, because we have more than 100 rooms in the tenant, and it doesn't return all of them.
Our aim was to get all the rooms from the 1st floor.

We did solve this by creating a distribution list in the tenant with attribute -RoomList.
We then added 1stfloormeetingroomright@gmail.com in the distribution list 1stfloor@gmail.com.

After that, if we call

ClearCollect(AllRooms, Office365.GetRoomsInRoomList("1stfloor@gmail.com")

it will bring only the rooms from the 1st floor (which are less than 100).

Thanks,
Ovidiu

Was this reply helpful? Yes No