Power Apps Desk Booking Template Broken? Error with Office365.GetRoomsInRoomList() function?

Like (6) Share

Report

Posted on 7 Mar 2025 10:16:03 by EB-07031015-0

Hi all,

Is anyone else encountering issues with apps built on the Desk Booking Power Apps template?

I am getting an error when trying to load desks to a collection through the Office365.GetRoomsInRoomList() function. This was working on 6th March and now appears to not be working.

The below is a part of the error message I am receiving:

"message": "The response is not in a JSON format.",
"innerError": "Cannot read server response."

However nothing has been changed to edit the JSON format that is being received since yesterday.

Any thoughts appreciated or would be grateful to hear if other are experiencing the same issue

Many thanks,

Ethan

Categories:

Connectors

General Questions

All responses (5)

Answers (0)

Suggested answer

Alex James 2 on 03 Apr 2025 at 10:43:47

Like (0)

Report

Power Apps Desk Booking Template Broken? Error with Office365.GetRoomsInRoomList() function?

The cause of this is the depreciation of the Version 1 connectors, when changing over to version two you need to pay attention that the paths have slightly changed

E.G

GetRoomsInRoomList

value.Name

GetRoomsInRoomListV2

value.name

These changes break a lot of different sections in the booking template

First step is to go through and replace all of the connectors that are being used for collections

Here are a few from memory that you need to change to V2

App (OnSelect)

GetRoomLists

GetRooms

RoomSelectScreen(OnVisible)

GetRoomsInRoomList

FindMeetingTimes

After Replacing these you need to go through and change all of the references to lowercase.

easiest way to do this is with the App Checker, select the Formulas tab and it will tell you all the references that are broken.

After fixing these the booking Page should work.
JT-12031057-0 2 on 12 Mar 2025 at 10:59:23

Like (0)

Report

Power Apps Desk Booking Template Broken? Error with Office365.GetRoomsInRoomList() function?

I too have this problem. I have updated the connector to Office365Outlook and updated to V2 of the formulas.

I now get an error here:

ClearCollect(AllRooms, AddColumns(RenameColumns(AllRooms, Result, Email), Name, LookUp(AllRooms, Email = Address).Name));

A column named 'Email' already exists.

A column named 'Name' already exists.

Can anyone assist?
David Kocman 5 on 11 Mar 2025 at 07:59:23

Like (1)

Report
Power Apps Desk Booking Template Broken? Error with Office365.GetRoomsInRoomList() function?

Hi,

I have actually deleted the Office365 connector altogether from the app and rewrote all connector actions with the Office365Outlook, so for your scenario, I have used the FindMeetingTimesV2 function.

ClearCollect(AvailableRooms, Office365Outlook.FindMeetingTimesV2({RequiredAttendees: AllRoomsConnector, ... })),

Note: the Office365Outlook V2 versions return names of attributes starting with lower case letter instead of capital letter.

Hope this helps!
David
boidos 10 on 10 Mar 2025 at 23:45:20

Like (0)

Report

Power Apps Desk Booking Template Broken? Error with Office365.GetRoomsInRoomList() function?

Hi David and Ethan, I have this issue as well, Did you change

ClearCollect(AllRooms, Office365.GetRoomsInRoomList(RoomsListsGallery.Selected.Address).value)

to

ClearCollect(AllRooms, Office365Outlook.GetRoomsInRoomListV2(RoomsListsGallery.Selected.Address).value)

When I update as above I get an error with the Findmeetingtimes connector

ClearCollect(AvailableRooms, Office365.FindMeetingTimes({RequiredAttendees: AllRoomsConnector, IsOrganizerOptional: true,

Start: StartDateTimeUTC, End: EndDateTimeUTC, MeetingDuration: DateDiff(StartDateTime, EndDateTime, TimeUnit.Minutes),

MinimumAttendeePercentage: "1", ActivityDomain: "Unrestricted"}));

I get a response

"BadArgument",

"message": "Attendees must be added if the organizer is optional",

cheers
Suggested answer

David Kocman 5 on 10 Mar 2025 at 10:05:29

Like (1)

Report

Power Apps Desk Booking Template Broken? Error with Office365.GetRoomsInRoomList() function?

Hi Ethan.

I have also came across this error in our application based on the Book a room template. It uses Office365 connector, which seems to have become deprecated.

What I have done, to fix this, is to add a new connector Office365Outlook and use GetRoomsInRoomListV2 function.

Hope this helps!
David