web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Connecting different S...

Power Apps

Unanswered

Connecting different SharePoint lists to a gallery based on a dropdown

(1) Share

Report

Report

Posted on by Markswan20

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?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
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
Markswan20 121 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Join the conversation