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.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (31,056)