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?
For me in these scenarios I use Collect.
Someone else showed a way of just doing it real time
Items = [SharePointList1, SharePointList2]
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?
You don't need Gallery1 and 2. You can delete them.
For Items in Gallery3 use
That should get you all of the items in 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
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.
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.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand