Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Connecting different SharePoint lists to a gallery based on a dropdown

(1) ShareShare
ReportReport
Posted on 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
    Markswan20 121 on at
    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
    M_Ali_SZ365 1,110 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard