Populate gallery with items from multiple collections

Like (0) Share

Report

Posted on 18 May 2021 13:33:01 by Iantaylor2050

506

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

I have the same question (0)

All responses (3)

Answers (1)

RandyHayes 76,291 Super User 2024 Season 1 on 18 May 2021 at 13:39:02

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.

Was this reply helpful? Yes No
Iantaylor2050 506 on 19 May 2021 at 01:27:02

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 ?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,291 Super User 2024 Season 1 on 19 May 2021 at 15:05:56

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

Was this reply helpful? Yes No