Power Platform Community Forum Thread Details

I would like to create a collection that contains the resource rooms in our tennant.

First data source: "Rooms"
ClearCollect(Rooms,Office365Outlook.GetRoomsV2().value)

This gives you a name of the calendar and address field.

Second data source: "CalendarIDs"

ClearCollect(CalendarIDs, Office365Outlook.CalendarGetTablesV2().value)

This gives you ID and tha name of the calendar.

In the end I Create collection called "CalendarsDataSource"

ClearCollect(
 CalendarsDataSource,
 {
 Id: LookUp(
 Office365Outlook.CalendarGetTablesV2().value,
 "Luna" = name,
 id
 ),
 Name: LookUp(
 Office365Outlook.CalendarGetTablesV2().value,
 "Luna" = name,
 name
 ),
 Address: LookUp(
 Office365Outlook.GetRoomsV2().value,
 "Luna" = name,
 address
 )
 }
)

This will merge the two data source and gives a table with the address, calendar's ID and name

There are tons of rooms in our tenant so I would like to insert this in a ForAll() function

Categories:

Building Power Apps

After a little more inspection, I came up with this, which looks like it's working. I started by making the variables easier by renaming the column names in the rooms and calendarIDs collections:

ClearCollect(Rooms,Office365Outlook.GetRoomsV2().value);
ClearCollect(CalendarIDs, Office365Outlook.CalendarGetTablesV2().value);
Clear(MyRoomsList);Clear(MyCalendarIDs);
ForAll(Rooms,Collect(MyRoomsList,{RoomName: name, RoomAddress: address}));
ForAll(CalendarIDs,Collect(MyCalendarIDs,{CalendarName: name, CalendarID: id}));

Then I did this formula to join them:

ForAll(MyRoomsList,
Collect(
 CalData,
 {
 RmName:RoomName,
 RmAddress:RoomAddress,
 CalID: LookUp(MyCalendarIDs,CalendarName=RoomName,CalendarID)
 }
))