Power Platform Community Forum Thread Details

Hello Champions

I am using the below code to filter the data through CB selection, and in code screen I am not seeing any code error. But when I select the values in combo boxes data not filtering. could you please help me. And please provide the corrected code if you can without delegation error.

Filter(
View_MediaDeposits_Overview,
Or(
IsBlank(CBStoreNumberMD_1.SelectedItems),
IsEmpty(CBStoreNumberMD_1.SelectedItems),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,1).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,2).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,3).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,4).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,5).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,6).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,7).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,8).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,9).Value),
StoreNumber = Text(Index(CBStoreNumberMD_1.SelectedItems,10).Value)
),Or(
IsBlank(CBStoreNameMD_1.SelectedItems),
IsEmpty(CBStoreNameMD_1.SelectedItems),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,1).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,2).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,3).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,4).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,5).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,6).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,7).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,8).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,9).Value),
StoreName = Text(Index(CBStoreNameMD_1.SelectedItems,10).Value)
),
Value(TextInput_Total_MD_1.Text) = Amount || IsBlank(TextInput_Total_MD_1.Text),
IsBlank(DatePicker_From_MD_1.Value) || IsBlank(DatePicker_To_MD_1.Value) || SalesDate >= DatePicker_From_MD_1.Value && SalesDate <= DatePicker_To_MD_1.Value
)

Categories:

Building Power Apps

Hi @Innrg ,

Firstly, you are never going to get that completely Delegable, but try this

With(
 {
 wData:
 Filter(
 View_MediaDeposits_Overview,
 (
 Amount = Value(TextInput_Total_MD_1.Text) = || 
 IsBlank(TextInput_Total_MD_1.Text)
 ) &&
 (
 (
 IsBlank(DatePicker_From_MD_1.Value) || 
 IsBlank(DatePicker_To_MD_1.Value) 
 ) || 
 (
 SalesDate >= DatePicker_From_MD_1.SelectedDate && 
 SalesDate <= DatePicker_To_MD_1.SelectedDate
 )
 )
 )
 },
 With(
 {
 wData2:
 If(
 IsEmpty(CBStoreNumberMD_1.SelectedItems),
 wData,
 Ungroup(
 ForAll(
 CBStoreNumberMD_1.SelectedItems As aSel,
 Filter(
 wData,
 StoreNumber = aSel.Value
 )
 ),
 "Value
 )
 )
 },
 If(
 IsEmpty(CBStoreNameMD_1.SelectedItems),
 wData2,
 Ungroup(
 ForAll(
 CBStoreNameMD_1.SelectedItems As aSel2,
 Filter(
 wData,
 StoreName = aSel2.Value
 )
 ),
 "Value
 )
 )
 )
 )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps