Power Platform Community Forum Thread Details

In my apps ,I have many combobox to let my user choose , If use let "Spec" field "empty" , how can I let my gallery to show data ??

Annotation 2020-08-05 141347.jpg

in this gallery's "ITEM" , I config like below

Filter(APP1,APPROVAL=If(General_affairs_query_approval_or_not.SelectedText.Value="已審核","Y","N") && Processed=If(General_affairs_query_process_or_not.SelectedText.Value="已採購","Y","N") && Value(Left(Title,8)) >= Value(Text(General_affairs_query_start_date.SelectedDate,"[$-en-US]yyyymmdd")) && Value(Left(Title,8)) <= Value(Text(General_affairs_query_end_date.SelectedDate,"[$-en-US]yyyymmdd")) && item_name= General_affairs_query_catagory.Selected.Result &&item_Quantity=General_affairs_query_spec.Selected.item_name)

Annotation 2020-08-05 141417.jpg

Categories:

Building Power Apps

After a while to search google and MS formula , finally I found solution to overcome my problem ...

The point is ..........If(IsBlank(General_affairs_query_catagory.Selected.Result), true ,item_name=General_affairs_query_catagory.Selected.Result)

==>so even the filter condition is empty , it will show all data under other filter condition value

YES!

😁 😁 😁 😁 😁 😁 😁 😁 😁

Annotation 2020-08-06 085805.jpg

SortByColumns(Filter([@APP1],Processed=If(General_affairs_query_process_or_not.SelectedText.Value="已採購","Y","N")&&APPROVAL=If(General_affairs_query_approval_or_not.SelectedText.Value="已審核","Y","N")&&Value(Left(Title,8))>=Value(Text(General_affairs_query_start_date.SelectedDate,"[$-en-US]yyyymmdd"))&&Value(Left(Title,8))<=Value(Text(General_affairs_query_end_date.SelectedDate,"[$-en-US]yyyymmdd"))&&If(IsBlank(General_affairs_query_catagory.Selected.Result), true ,item_name=General_affairs_query_catagory.Selected.Result) && If(IsBlank(General_affairs_query_spec.Selected.item_name),true,item_Quantity=General_affairs_query_spec.Selected.item_name)),"Title",Descending)