web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Office365Users Nested ...
Power Apps
Answered

Office365Users Nested Gallery

(0) ShareShare
ReportReport
Posted on by

Please help!

 

I have a SPlist with a person column and start and end date for various tasks. I need to show these in a weekly grid with a line for each person and a label for each day. I have all of the logic working correctly but I can only get each line of the horizontal nested gallery to show one set of data. So if a person has two rows with different start and end dates, only the first one shows?

 

my primary gallery is based around Office365Users but how can get each line of the horizontal nested gallery to show multiple start and end dates for each person as they will have different tasks each week. 

Categories:
I have the same question (0)
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @jed76 ,

     

    Could you please share more details about your scenario? What are the formulas for Items property of the TWO Galleries? 

     

    I assume your person column allows single selection, and the start and end date columns are of type Date only. Gallery1 Items:

    Office365Users.SearchUser({searchTerm:""})

    Nested Gallery 2 Items:

    Filter(YourList, PersonColumn.DisplayName = ThisItem.DisplayName)

    Labels inside Gallery2:

    ThisItem.StartDate
    ThisItem.EndDate

     

    My list:

    vjefferni_1-1664177780420.png

    My App:

    vjefferni_2-1664177888979.png

     

    Best regards,

  • Verified answer
    jed76 Profile Picture
    on at

    Many thanks. I have since sorted this. I solved it by using a separate vertical gallery for each day of the week. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 762

#2
11manish Profile Picture

11manish 640

#3
Valantis Profile Picture

Valantis 548

Last 30 days Overall leaderboard