Multiple Sharepoint lists display in one gallery

(0) Share

Report

Posted on by AT_AlanTse123

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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mehmet_Powerapps 26 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report
Copy link

Link copied!

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".

Was this reply helpful? Yes No
Mehmet_Powerapps 26 on at

Like (0)

Report
Copy link

Link copied!

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

.

.

.

Was this reply helpful? Yes No
Suggested answer

AT_AlanTse123 181 on at

Like (0)

Report
Copy link

Link copied!

I found that it can use ShowColumns in the ClearCollect.

That it works.

Was this reply helpful? Yes No
Verified answer

Shravyashree_Shetty 53 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No