Announcements
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.
Collect(CombinedLists, SharePointList1)
Collect(CombinedLists, SharePointList2)
Someone else showed a way of just doing it real time
Items = [SharePointList1, SharePointList2]
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?
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.
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
Post some screenshots. Being different sites doesn't matter. 🙂
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.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 305 Most Valuable Professional
11manish 212
Valantis 167
