Skip to main content
Community site session details

Community site session details

Session Id : LGTpauIpcqFdfpvgjh8GFJ
Power Apps - Building Power Apps
Unanswered

Connecting different SharePoint lists to a gallery based on a dropdown

Like (1) ShareShare
ReportReport
Posted on 10 Jul 2024 21:04:55 by 121

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?

 

  • Markswan20 Profile Picture
    121 on 11 Jul 2024 at 04:37:24
    Re: Connecting different 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

  • M_Ali_SZ365 Profile Picture
    1,110 on 10 Jul 2024 at 21:13:21
    Re: Connecting different SharePoint lists to a gallery based on a dropdown

    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 

     

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473