Power Apps设置Gallery的参数过滤

 

 

在下拉列表的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)