在下拉列表的OnSelect属性中设置：
ClearCollect(statusCol,{Name:Blank()});
Collect(statusCol,Choices([@'Scrap Parts Application Order'].'Order Status状态'));
设置Gallery的数据源为
SortByColumns(Filter('Scrap Parts Application Order',ddProductionLine.Selected.Value=Blank() Or 'Production Line'.Value=ddProductionLine.Selected.Value,ddStatus.Selected.Value=Blank() Or 'Order Status状态'.Value=ddStatus.Selected.Value,收料日期>=dtpStart.SelectedDate,收料日期<=dtpEnd.SelectedDate)
,"ID",Descending)