cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jed76
Post Partisan
Post Partisan

Office365Users Nested Gallery

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
jed76
Post Partisan
Post Partisan

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

View solution in original post

2 REPLIES 2
v-jefferni
Community Support
Community Support

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,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

jed76
Post Partisan
Post Partisan

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

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.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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