6
Hello maybe somebody can give me advice .
I would like to collect for this table ;
Vacation dates and weeks etc that everything can cooperate with this tabel.
Thats how looks vacation date chooser.
and collection inside
All what i need is to merge that information with exist tabel.
Hi,
to use info from different data sources and merge it into one collection you can use addcolumns like this:
Share
Report
All responses (
Answers (
ClearCollect(
colMergedCollection, //name of the new collection
AddColumns(
colCollectionOne, //name of the first collection (ususaly larger of the two)
"name_of_new_column_1",
LookUp(
colCollectionTwo, //name of collection that contains columns to add
relation_column = colCollectionOne[@relation_column]
).name_of_source_column_1,
"name_of_new_column_2",
LookUp(
colCollectionTwo,
relation_column = colCollectionOne[@relation_column]
).name_of_source_column_2
))and so on.
the relation_column is needed to match the records to each other, not sure if you have a column like that you can use the system id column from the main list and patch it to the second list every time new record is added, or you can create a new column and store GUID() in it.
Seb
