Answered

Office365Users Nested Gallery

Like (0) Share

Report

Posted on 24 Sep 2022 13:11:33 by jed76

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:

General Questions

All responses (2)

Answers (1)

Verified answer

jed76 on 26 Sep 2022 at 08:12:41

Like (1)

Report

Re: Office365Users Nested Gallery

Many thanks. I have since sorted this. I solved it by using a separate vertical gallery for each day of the week.
v-jefferni on 26 Sep 2022 at 07:38:25

Like (0)

Report
Re: Office365Users Nested Gallery

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:

My App:

Best regards,