Trying to Group By week commencing column:
I realised that GroupBy does not support Choice Columns so if I change the column to a date column it works.
I have created a gallery and used the below formula on the ‘items’ control.
Then within the gallery I have added a Label (on the Text control ThisItem.Week_x0020_Commencing_x0020_2) and a list box (ThisItem.Week.Title)
It groups the items perfectly but when I come to click into one of the items, how can you do this? As well as adding a list box I tried adding a gallery within the gallery but having the same problem, unable to click into the individual item.
Below is my test example, the first list box is because they don’t have a week commencing selected as it’s before I added the new date picker.
Are you using multiple data sources inside the same gallery control? Or is the list box just stores the data of a multiple select enabled column? If it's the latter, then you should select each part of the gallery, not the options inside the list box. To do this, you just need to insert a navigation button/icon in the template part of the gallery(first part).
If its the former, then please share the related formulas for the list box.