hi,
i create a new collection from SP list by collecting all items base on CheckPoint Value
Refresh icon:
//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"].
Please help.
Thanks,
Ratana
Hi @ratanapouy
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.
Hey @ratanapouy
ClearCollect(DatabaseItem, Filter(Database, DateValue(Text(DateValue,"[$-en-US]yyyymmdd")) >= DatePicker1.SelectedDate))
hi,
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.
Hi @ratanapouy
In SP list, it is single text which calculated as follow:
=TEXT(Date_Time_CheckIn,"yyyymmdd")
Hey @ratanapouy
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.
Hi @ratanapouy
ClearCollect(DatabaseItem, Filter(tbl_CheckPoint_Data, CheckPoint.Value = CheckPointMaster_1.Selected.checkpoint && DateValue(DateValue) >= DatePicker1.SelectedDate));
User | Count |
---|---|
194 | |
126 | |
89 | |
48 | |
42 |
User | Count |
---|---|
280 | |
160 | |
137 | |
82 | |
76 |