ForAll for creating a collection

(0) Share

Report

Posted on by Tibor4

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

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Deleted

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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) } ))

Was this reply helpful? Yes No