Populate gallery with items from multiple collections

(0) Share

Report

Posted on by Iantaylor2050

502

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:

General Questions

All responses (3)

Answers (1)

Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report
Re: Populate gallery with items from multiple collections

@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" )
Iantaylor2050 502 on at

Like (0)

Report

Re: Populate gallery with items from multiple collections

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 ?
RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report
Re: Populate gallery with items from multiple collections

@Iantaylor2050

Set your Items property to the following:

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

I hope this is helpful for you.