ClearCollect function - Insert two data sources in one gallery

(0) Share

Report

Posted on by PowerSäm

775

Hello all,

I have a question regarding the integration of multiple data sources in a gallery in PowerApps. I have read that the only way to do this is to use the ClearCollect funktion.

I have built the following so far:

All created vacation requests are displayed in the gallery with the respective status. The data is stored in a sharepoint list. But now I have created another sharepoint list, where all travel requests are in it, and these must also be displayed in the gallery. How can I now use the ClearCollect function to display both data sources in one gallery?

Without destroying the already created status formula. (See picture) That means, if I click afterwards on the respective status button like "Genehmigt", all requests must be indicated (vacation requests and travel requests) which were approved.

Some ideas?

I hope I could explain it relatively understandable.

Many thanks in advance

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@PowerSäm ,

Just think that the Sharepoint server side don't know to execute the if () part.

Try this approach:

If(varFilter="Alle"; Datasource; Filter(DataSource;Status.Value=varFilter) )

Importing all data from a datasource is not a solution when we talking about large datasource, the server answer will be limited to first 500-2000 records.

Hope it helps !
Verified answer

max81 860 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @PowerSäm ,

you can use "collect" (not clearcollect) to create a collection with the data of both SharePoint lists.
To show it easily in one gallery, the field names in both lists must be the same, otherwise you get additional columns in your collection.
Than you must change the data source for your gallery to the collection.
So maybe replace "Urlaubsplanung" with "colUrlaubReise".

Example:
SharePoint Urlaubsplanung
ID Title SingleLineText ColumnA
1 Test bla 111
2 New Test blo 222

SharePoint Reiseplanung
ID Title SingleLineText ColumnB
1 TitleA ja 333
2 TitleB nein 444

Collect(colUrlaubReise, Urlaubsplanung); Collect(colUrlaubReise, Reiseplanung);

colUrlaubReise
ID Title SingleLineText ColumnA ColumnB
1 Test bla 111
2 New Test blo 222
1 TitleA ja 333
2 TitleB nein 444

Greetings,
Max
PowerSäm 775 on at

Like
a
(1)

Report
Copy link

Link copied!

@max81 Thanks for your replay.
That worked perfectly!
Mana 171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi ,
What if the columns are not the same, I have the following Data sourses :
Collect(ListElements, Filter(Office365Groups.ListOwnedGroups().value, "Group" in displayName));
Collect(ListElements,Office365Users.SearchUser({top:999}))

but I cant use ListElements in my Last galley since I have 2 different columns to join; displayName and DisplayName.
Can you pls help me to merge these twodata sources together?