cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Buddy2019
Helper I
Helper I

Meeting Capture: Display usernames who are available

How can I display all available names inside the gallery when the user selects a specific time and hits submit ?

 

 Currently, the meeting time values are being stored inside the collections correctly but I'm not sure how to extract only the available users names during the specific timeslot. 

Item01.PNG

Item02.PNG

I tried the following to filter the gallery but It did not work.

 

Filter(MeetingTimes, AttendeeAvailability,Availability = "Free" || Availability = "Tentative"),", " & LookUp(FollowUpMeetingAttendees, UserPrincipalName = Attendee.EmailAddress.Address).DisplayName

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Buddy2019 ,

Do you want to display the names in a separate gallery on your own?

 

I have made a test on my side, please take a try with the following workaround:3.JPG

Add the following formula within the OnSelect property of the "Find Available Times" button:

Clear(FinalResult);
ForAll(
         MeetingTimes,
         ForAll(
                AttendeeAvailability,
                If(
                    Availability="Free"||Availability="Tentative",
                    Collect(FinalResult, LookUp(FollowUpMeetingAttendees, UserPrincipalName = Attendee.EmailAddress.Address).DisplayName)
                )
         )
)

Then set the Items property of your own Gallery to following:

FinalResult

Add a Label within your Gallery, set the Text property to following:

ThisItem.Value

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-xida-msft
Community Support
Community Support

Hi @Buddy2019 ,

Could you please share a bit more about your scenario?

Do you want to filter your AvailableTimesGall gallery items to display all  available names based on a specific timeslot?

 

Based on the formula that you mentioned, I think there is something wrong with it. Within the MeetingTimes collection, the AttendeeAvailability.Availability formula returned is a nested Table value, which could not be compared with a Text value "Free" or "Tentative".

 

As an alternative solution, you could consider add another Gallery (Gallery1, nested gallery) within the AvailableTimesGall gallery, then set the Items property of the Gallery1 to following:

Split(
Concat(
Filter(ThisItem.AttendeeAvailability, Availability = "Free" || Availability = "Tentative"),
LookUp(FollowUpMeetingAttendees, UserPrincipalName = Attendee.EmailAddress.Address).DisplayName & ", "
),
", "
)

Set the Text property of the Label within the Gallery1 to following:

ThisItem.Result

2.JPG

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-xida-msft ,

 

Thanks for getting back. The solution works correctly as I only want to display all available users for a specific time slot. However, in your example you used a nested gallery. Is it possible to do this without using a nested gallery? I would like to display the names in a separate gallery on its own.

Thank you again.

 

 

Hi @Buddy2019 ,

Do you want to display the names in a separate gallery on your own?

 

I have made a test on my side, please take a try with the following workaround:3.JPG

Add the following formula within the OnSelect property of the "Find Available Times" button:

Clear(FinalResult);
ForAll(
         MeetingTimes,
         ForAll(
                AttendeeAvailability,
                If(
                    Availability="Free"||Availability="Tentative",
                    Collect(FinalResult, LookUp(FollowUpMeetingAttendees, UserPrincipalName = Attendee.EmailAddress.Address).DisplayName)
                )
         )
)

Then set the Items property of your own Gallery to following:

FinalResult

Add a Label within your Gallery, set the Text property to following:

ThisItem.Value

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

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