cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to get data from nested collection?

Hi all,
I have nested collection(GetBsyCollection) like below,
collections4.PNG

If I click on MeetingTimeSuggestion then there is another collection like below
collection5.PNG

and then If I click on AttendeeAvailability then there is another collection like below
collection6.PNG

and then If I click on Attendee then there is another collection like below

collection7.PNG
and then If I click on EmailAddress then there is another collection like below

collection9.PNG
My Question is how to get EmailAddress where Availability = "Busy" from the AttendeeAvailability Collection and save it to a new collection?

Any help is appreciated. Thanks in advance.

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: How to get data from nested collection?

Hi@jean2,

Do you want to access your nested collection?

Could you please share more about your collection formula? Please post the formula for how you create the nested collection.

I have a test on my side, here is my nested collection formula.

 

learCollect(
    GetBsyCollection,
    {
        Title: "Level 1A",
        MeetingTimeSuggestion: {
            Title2: "Level 2A",
            AttendeeAvailability: {
                Availability: "Busy",
                Attendee: {
                    EmailAddress:{Address:"chocolatos@outlook.com"},
                    Type:"Required"
                }
            }
        }
    }
)

 

Do you want to get the EmailAddress and save it to a new collection? Please take a try as below.

Add a Gallery populated with the MeetingTimeSuggestion and set the subtitle Text property as below.

 

ThisItem.MeetingTimeSuggestion.AttendeeAvailability.Attendee.EmailAddress.Address

 

Add a Button and set the OnSelect property as below.

 

Collect(Tem,Gallery2.AllItems)

 

Open the Collection from File>>Collection, you can see the Tem collection containing EmailAddress as below.

070601.png

Best Regards,

Qi

Highlighted
Frequent Visitor

Re: How to get data from nested collection?

Hi @v-qiaqi-msft, thank you for response my question. 
I tried the formula you gave, and it worked well. but in my case my nested collection from this code which uses the Office365.FindMeetingTimes() function

 

ClearCollect(AvailableInResourceCollection,
    ForAll(DateTimeBookingCollectionUTC,
       Office365.FindMeetingTimes(
          {
              RequiredAttendees: AllRoomsConnector,
              IsOrganizerOptional:true,
              Start: StartTimesUTC,
              End: EndTimesUTC,
              MeetingDuration: DateDiff(
                  StartTimeBooking,
                  EndTimeBooking,
                  Minutes
              ),
              MinimumAttendeePercentage: "1",
              ActivityDomain:"Unrestricted"
          }
       )
    )
);
ClearCollect( 
    GetBsyCollection, 
    Filter( 
        AvailableInResourceCollection, Not("Free" in Concat(MeetingTimeSuggestions, OrganizerAvailability & ";")) 
    )
);

 

Yes, I want to get the emailaddress where Attendee = "Busy" and save it to new collection

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,653)