i create a new collection from SP list by collecting all items base on CheckPoint Value
//Create collectin by Checkpoint
ClearCollect(Database, Filter(tbl_CheckPoint_Data, CheckPoint.Value = CheckPointMaster_1.Selected.checkpoint));
//Filter by date range
ClearCollect(DatabaseItem, Filter(Database, DateValue(Text(DateValue,"[$-en-US]yyyymmdd")) >= DateValue(Label5.Text)));
the problem is, if i choose Check Point "WH05", all data is coming from SP List into collection "Database" then fillter collection "Database" into Collection "DatabaseItem"; but i am wondering, when i choose Check Point "WH08" then click Refresh.
Data retrieve from SP List into Collection "Database"; but nothing in Collection "DatabaseItem". i go to check there are records in SP list for Check Point "WH08" around 58 records base on date selection 09/02/2019 [dateformat: "mm/dd/yyyy"].
Label5.Text is date value which get datevalue from datepicker. i just wanted to try a new way to filter date range. Eventually, result is nothing on what i decribed above.
ClearCollect(DatabaseItem, Filter(Database, DateValue(Text(DateValue,"[$-en-US]yyyymmdd")) >= DatePicker1.SelectedDate))
DateValue column set format "yyyyddmm" which is calculated from other date comlumn "Date_Time_CheckIn". I wanted to try many ways to filter data in collection. Still doens't work. i get stuck and looking in records to find out the root cause.
is not succesfully gotten data. Do i have issue with data delegation?
Export SP list into Excel, i found that Check Point "WH08" has over 2k records, others have below 1k records.
ClearCollect(DatabaseItem, Filter(tbl_CheckPoint_Data, CheckPoint.Value = CheckPointMaster_1.Selected.checkpoint && DateValue(DateValue) >= DatePicker1.SelectedDate));