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

(6) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

David Kocman 5 on at

Like (1)

Report

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

Was this reply helpful? Yes No
boidos 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
David Kocman 5 on at

Like (1)

Report
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

Was this reply helpful? Yes No
JT-12031057-0 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Alex James 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No