cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Is there a way to get two Galleries of data to pull through into one Gallery?

Initially I was trying to get a Gallery to pull from two different SharePoint lists to display the information but as I am struggling to do this, I am wondering if it is easier to pull them through as seperate galleries on my app and then create a third gallery which pulls the information from the other two?

 

Can anyone advise what the best way to do this is?

7 REPLIES 7
Highlighted
Super User
Super User

Re: Is there a way to get two Galleries of data to pull through into one Gallery?

For me in these scenarios I use Collect.

 

Collect(CombinedLists, SharePointList1)

Collect(CombinedLists, SharePointList2) 

 

Someone else showed a way of just doing it real time

 

Items = [SharePointList1, SharePointList2]

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Highlighted
Helper IV
Helper IV

Re: Is there a way to get two Galleries of data to pull through into one Gallery?

Hi @Shanescows

 

Thanks for your response. Sorry you've lost me a little bit with this. My two data sources are Site Pages_1 and Site Pages_2.

 

I have got the two galleries to seperately bring through the data for these and that works fine. And now I am unsure of what to put in my properites for the third galleries which I essentially want as a hybrid of the two lists.

 

Can you help?

Highlighted
Super User
Super User

Re: Is there a way to get two Galleries of data to pull through into one Gallery?

You don't need Gallery1 and 2. You can delete them.

 

For Items in Gallery3 use

 

[SitePages1, SitePages2] 

 

That should get you all of the items in one gallery. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Highlighted
Helper IV
Helper IV

Re: Is there a way to get two Galleries of data to pull through into one Gallery?

This isn't working unfortunately. I suspect it has something to do with it being different SharePoint lists within different sites. The column names are all the same but it doesn't seem to be matching up perfectly and throwing out errors

Highlighted
Super User
Super User

Re: Is there a way to get two Galleries of data to pull through into one Gallery?

Post some screenshots. Being different sites doesn't matter. 🙂 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Highlighted
Helper IV
Helper IV

Re: Is there a way to get two Galleries of data to pull through into one Gallery?

Thank you. I'm not sure what I'm doing wrong here. The bottom gallery is the one I need to try and get working but as you can see it is pulling through errors.

 

 

PowerApps.png

Highlighted
Helper IV
Helper IV

Re: Is there a way to get two Galleries of data to pull through into one Gallery?

Hi @Shanescows

 

I have managed to figure out why there were errors but that then leads me onto my next question, how do I get it to pull the data from both lists? For example they both have a column named "Title" but it won't let me use ThisItem.Title and pull the data from both lists.

 

This screenshot is better at explaining what I need. I essentially want the data displayed in the top two galleries to all just be shown in one gallery where I can use my filters etc.

 

 

PowerApps.png

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,805)