It's important to check the following:
- Will either of your lists contain more than 2000 items that you need to store?
- Are the columns of both lists identical? If not, which columns do you need to be displayed in your gallery?
The actual formula isnt that intresting;
Clear(colVacations);
Collect(
colVacations,
VacationAccepted
);
Collect(
colVacations,
VacationDeclined
)
This is assuming that the columns are identical.
Also please bear in mind that if you use this to update your data sources, this collection will not be updated with it, so you have to do this every time you make a change.
The cleaner solution would be to just combine the two sharepoint lists into one sharepoint list.
