I have created an app that has a calendar for 5 different locations, each one will potentially have around 900 records at any one point, i have tried to use 1 SharePoint list but have hit the delegable issue.
I use a Dropdown to display the relevant calendar location,
My thought process is that if i can use multiple SharePoint lists this would solve my delegation issue,
My question is can i connect multiple SharePoint Lists to a Gallery based on a Dropdown?
Thanks for the quick reply, i can manipulate the fields to match the requirement, each of the lists are exactly the same how would i add a sort to the gallery to utilise the field across all called 'Job Time'?
Thanks
Yes, you can connect multiple SharePoint lists to a Gallery based on a dropdown selection
write this code in the item property dropdown
["Location 1", "Location 2", "Location 3", "Location 4", "Location 5"]
write this code in items of the gallery
Switch(
Dropdown1.Selected.Value,
"Location 1", CalendarLocation1,
"Location 2", CalendarLocation2,
"Location 3", CalendarLocation3,
"Location 4", CalendarLocation4,
"Location 5", CalendarLocation5
)
if it works the accept my issue and if not work then feel free to ask me