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 Apps
Unanswered

Gallery Question

(0) ShareShare
ReportReport
Posted on by

Hi

Can anyone think how I might achieve the following please:

 

I have created a weekly calendar where each day is populated if a person has a task scheduled for that particular day. As shown in the screenshot, it works well, but I'd like to be able to have a 'permanent' row for each member of staff rather than them dynamically changing if they have a task associated for a particular date. I'd like a gallery or list showing all staff down the left hand side and then a box appears if that particular staff member has something scheduled for a certain day, always on their own line. 

 

Many thanks, Justin 

 

jed76_0-1662646694378.png

 

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @jed76 

    Yes, you will need to utilize a nested gallery.

    Your primary gallery would be a vertical gallery with all the names for the records/table and then your nested gallery would be a horizontal gallery with the weekday data in it.

     

    I hope this is helpful for you.

  • jed76 Profile Picture
    on at

    Thanks. How would I ensure that the items in the nest gallery are always on the same line as the name shown in the primary one?

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @jed76 

    That is the nature of the nested gallery...you are going to put it in the primary template.

    So, your template would have first, the label for the person name, then then a horizontal gallery right next to it...it would always be next to the name.

    Getting the proper data in the two galleries will be all about the Items properties for those galleries.

  • jed76 Profile Picture
    on at

    Many thanks. An example of the data and how this achieved would be useful. I’m not sure how to ensure the data in the primary gallery would always be the same regardless of what items appear in the nested one?

  • jed76 Profile Picture
    on at

    can the primary gallery of names come from the list of Office 365 users? 

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @jed76 

    Yes, all can come from anything you want.  This is where the glory of PowerApps comes into play - shaping your data as you need it to be.

     

    So, for example, your primary gallery Items can be something like:

     

    AddColumns(
     Office365Users.SearchUserV2({isSearchTermRequired: false}).value,
     "weekData", 
     Filter(youreventList,
     userIdentifer = Mail &&
     eventDate>=startOfWeekDate &&
     eventDate< endOfWeekDate
     )
    )

     

    Then a label in your primary gallery with a Text property of: ThisItem.DisplayName

    and the nested gallery with an Items property of: Thisitem.weekData

    would give you the data to all galleries.

     

    Then in the nested, you can add labels and whatever else you need which will reference the records of the event list (or whatever your table/list is)

  • jed76 Profile Picture
    on at

    Thank you very much. I’ll give this a try!!!

  • jed76 Profile Picture
    on at

    @RandyHayes  Sorry, I'm completely lost here. I have managed to create a vertical gallery which shows all of the Office365 user's names, but that's about it! How can I create the nested gallery to show tasks across a 7 day week as I have shown in the original screenshot please? Each person has a "StartDate" and "EndDate" column in my data collection. Any help would be massively appreciated. 

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @jed76 

    What is your Items property of the vertical gallery at this point?

    Have you added the horizontal gallery to your vertical gallery yet?

  • jed76 Profile Picture
    on at

    @RandyHayes @Thanks for this. I am going to get back on it this week and will let you know how I get on.

     

    so it’s a vertical gallery to post the user names and then a nested horizontal one to show the tasks?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard