cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerSäm
Continued Contributor
Continued Contributor

Insert two Sharepoint lists in only one gallery - Possible?

Hi all,

 

here is a quick question, is it possible to insert two different sharepoint lists in one gallery in powerapps? Maybe with a formula similar to the one shown in the picture?

 

PowerSm_0-1629979658429.png

 

If it is not possible how can I still have multiple lists appear in one gallery?


I have done the following. I have created a list in sharepoint for vacation requests and another one for business trips. But now I want all requests to be displayed on the home page in only one gallery, no matter if it is a leave or a travel request. Is it possible to combine them? Or can I merge two lists in sharepoint into one?

 

I hope my question has been explained clearly enough.

 

I am grateful for any help! Thanks in advance

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

List A

Colum1 Colum2 Colum3

List B

Colum1 Colum2 Column4

Collection:

Column1 Colum2 Column3 Column 4

View solution in original post

4 REPLIES 4
zmansuri
Super User
Super User

make sure both list have same schema.

Then

 

ClearCollect(colMain,List1,List2)

This will create a collection named colMain which will include data from both your list.

PowerSäm
Continued Contributor
Continued Contributor

Hi @zmansuri and thanks for your reply.

 

But one list contains some more and other columns than the other list. Is this still possible? Or do both lists have to be identical, i.e. with the same column names?

 

Thanks in advance!

List A

Colum1 Colum2 Colum3

List B

Colum1 Colum2 Column4

Collection:

Column1 Colum2 Column3 Column 4

PowerSäm
Continued Contributor
Continued Contributor

@zmansuri 

Thanks for your replay. That worked perfectly.

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,522)