Unanswered

Is there a way to filter server side "Office365.GetRooms().value" to avoid limited results (Delegable)

(0) Share

Report

Posted on by StuartSmith

225

I am trying to test something relating to "Meeting Capture" and "Meeting Screen" templates and need to display a filtered list of our meeting rooms to see if it can display a specific meeting room(s). Currently I am using "Filter(Office365.GetRooms().value, StartsWith(Name, FilterTextBox.Text))" but feel this is only pulling down 2000 records and filtering those records. Is there a way to filter all the meeting rooms server side and then display the results in a gallary? we have 1000's of meeting rooms, so even setting the non-delagable limit to 2000 isnt big enough.

Thanks in advance,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @StuartSmith ,

I'm afraid there's no way to avoid delegation problem in this function.

For now, PowerApps only supports three delegateable data sources:

Common Data Service

SharePoint

SQL Server

Office365 outlook connector is not included.

If the connector is not delegateable, it is not possible to avoid this problem.

Here's a doc about delegation in details for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Best regards,

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (1)

Report
Copy link

Link copied!

Thanks Phoebe, i feared that might be the case. I see on this page "https://docs.microsoft.com/en-us/connectors/office365/" there are several different "GetRooms" operators. There is "GetRooms", "GetRooms_V2", and then there is "GetRoomsInRoomList" & "GetRoomsInRoomList_v2", but cant find much information on the "GetRoomsInRoomList" operator. Are you aware of this command?

Alternatively, is it possible to create a collection of all meeting rooms and then filter the collection, etc? I am doing lots of searching to see if its possible to do this.

Was this reply helpful? Yes No