Populate gallery with items from multiple collections

(0) Share

Report

Posted on by Iantaylor2050

603

Hi All,

Need to populate gallery with items from multiple collections. Below are the 2 collections which I hold.

ClearCollect(
ModEve,
ShowColumns(
DataSource,
"Event",
"Modified",
"Author",
"Event_BL_Flag"
)
);

ClearCollect(
ModOrg,
ShowColumns(
DataSource,
"Event",
"Modified",
"Author",
"Event_BL_Flag"
)
);

This is the Gallery where I need to populate items from both the collections. Both collections have same columns. Any idea how to set the item property of Gallery to both collections ?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Iantaylor2050

Set your Items property to the following:

UnGroup( Table( {Items: ModEve} {Items: ModOrg} ), "Items" )

I hope this is helpful for you.

Was this reply helpful? Yes No
Iantaylor2050 603 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes

I tried using the above formula, however it throws error as below

Also, Can we use ThisItem.columnname for setting values in Gallery ?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Iantaylor2050

Sorry, forgot a comma. Please scrub through the formulas I provide as I type them by hand without the aide of a design editor.

Formula should be:

UnGroup( Table( {Items: ModEve}, {Items: ModOrg} ), "Items" )

Was this reply helpful? Yes No