web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Multiple Sharepoint li...
Power Apps
Answered

Multiple Sharepoint lists display in one gallery

(0) ShareShare
ReportReport
Posted on by 181
Good morning everyone!
 
 
I have 5 SharePoint list called Apple,Banana,Cat,Dog,Egg.
 
 
Apple structure: Title, Foreman, Labour
Banana structure: Title, Foreman, Labour
Cat structure: Title, Foreman, Labour
Dog structure: Title, Foreman, Labour
Egg structure: Zone, Title, Foreman, Labour,  Remote Site
 
I want to press the button to navigate the screen called "BrowseScreen_Archive".
 
In the "Browse Screen", it has one gallery, i want to combine these 5 SharePoint lists data and shown in the Gallery.
 
I found on the Internet that it can use ClearCollect to combine multiple SharePoint list as collection on the button.
 
I tried, it causes error which is "The function 'ClearCollect' has some invalid arguments." and i do not know to fix and how to set the Items in Gallery.
 
Button OnSelect Code:
ClearCollect(AllArchive,'Apple','Banana','Cat','Dog','Egg');
Navigate(BrowseScreen_Archive,ScreenTransition.UnCover);
 
Would anyone can help me?
Thank you very much.
 
 
 
 
 
 
Categories:
I have the same question (0)
  • Suggested answer
    Mehmet_Powerapps Profile Picture
    26 on at
    Hello, 
    i made some tests and tried to find the possible errors.
     
    I think, your SPlist's columns type are different. E.g. you have a column named Labour both on Apple and Banana lists. But the type of the columns are different in two lists. The columntype can be "Text" at Apple list but can be "Select" in Banana list.
     
    Because of that  CreateCollection  can not merge these two lists. 
  • AT_AlanTse123 Profile Picture
    181 on at
    Thank you CU02122023-0,  I checked the type of the columns in these five lists, all of the type of the columns is "Single Text".
  • Mehmet_Powerapps Profile Picture
    26 on at
    Hello  CU02122023-0
     
    can you add lists to ClearCollect() formula list by list. 
     
    e.g. 
    1. ClearCollect(AllArchive,'Apple') if all things is ok then next step
    2. ClearCollect(AllArchive,'Apple','Banana') if all things is ok then next step
    .
    .
    .
     
  • Suggested answer
    AT_AlanTse123 Profile Picture
    181 on at
    I found that it can use ShowColumns in the ClearCollect.
    That it works.
  • Verified answer
    Shravyashree_Shetty Profile Picture
    53 on at
    Hi,
     
    Can you Try 
     
    ClearCollect(ColApple,'Apple');  ClearCollect(ColCat,'Cat'); -----[Collect all the collections]
    ClearCollect(AllArchives,ColApple,ColCat)-------[Add all the collections]
     
     
    PLEASE GIVE THIS ANSWER A THUMBS UP, IF THIS HELPS AND ACCEPT THIS ANSWER AS A SOLUTION FOR FUTURE REFERENCE!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 273

#3
Kalathiya Profile Picture

Kalathiya 232 Super User 2026 Season 1

Last 30 days Overall leaderboard