Hey all, I have a problem. I have a datasource with tons of record. I figured out the way to collect them all, but the only collumn I see in my collection is ID. I've placed this query onStart in App. How can I assure that all the collumns will be collected?
Refresh('[dbo].[Picklist]');
Concurrent(
ClearCollect(
col1,
Filter(
'[dbo].[Picklist]',
ID >= 1 && ID <= 2000
)
),
ClearCollect(
col2,
Filter(
'[dbo].[Picklist]',
ID >= 2001 && ID <= 4000
)
),
ClearCollect(
col3,
Filter(
'[dbo].[Picklist]',
ID >= 4001 && ID <= 6000
)
),
ClearCollect(
col4,
Filter(
'[dbo].[Picklist]',
ID >= 6001 && ID <= 8000
)
),
ClearCollect(
col5,
Filter(
'[dbo].[Picklist]',
ID >= 8001 && ID <= 10000
)
),
ClearCollect(
col6,
Filter(
'[dbo].[Picklist]',
ID >= 10001 && ID <= 12000
)
),
ClearCollect(
col7,
Filter(
'[dbo].[Picklist]',
ID >= 12001 && ID <= 14000
)
),
ClearCollect(
col8,
Filter(
'[dbo].[Picklist]',
ID >= 14001 && ID <= 16000
)
),
ClearCollect(
col9,
Filter(
'[dbo].[Picklist]',
ID >= 16001 && ID <= 18000
)
),
ClearCollect(
col10,
Filter(
'[dbo].[Picklist]',
ID >= 18001 && ID <= 20000
)
),
ClearCollect(
col11,
Filter(
'[dbo].[Picklist]',
ID >= 20001 && ID <= 22000
)
),
ClearCollect(
col12,
Filter(
'[dbo].[Picklist]',
ID >= 22001 && ID <= 24000
)
),
ClearCollect(
col13,
Filter(
'[dbo].[Picklist]',
ID >= 24001 && ID <= 26000
)
),
ClearCollect(
col14,
Filter(
'[dbo].[Picklist]',
ID >= 26001 && ID <= 28000
)
),
ClearCollect(
col15,
Filter(
'[dbo].[Picklist]',
ID >= 28001 && ID <= 30000
)
),
ClearCollect(
col16,
Filter(
'[dbo].[Picklist]',
ID >= 30001 && ID <= 32000
)
),
ClearCollect(
col17,
Filter(
'[dbo].[Picklist]',
ID >= 32001 && ID <= 34000
)
),
ClearCollect(
col18,
Filter(
'[dbo].[Picklist]',
ID >= 34001 && ID <= 35000
)
)
);
ClearCollect(
colCombined,
col1,
col2,
col3,
col4,
col5,
col6,
col7,
col8,
col9,
col10,
col11,
col12,
col13,
col14,
col15,
col16,
col17,
col18
)
and my collections:
