Power Platform Community Forum Thread Details

I have a datatable created from a Sharepoint List that has a Date Column and several Text, number and currency columns. I have two date picker controls and a ListBox Control applied to the app screen.

My ListBox Items Property is:

Choices('DataSetName'.Store)

My datatable Items Property is:

Sort(Filter('DataSetName',Date>=DatePicker1.SelectedDate,Date<=DatePicker2.SelectedDate,Store.Value=ListBox1.SelectedText.Value),Date,Descending)

The Store property has 5 unique values in it.

I need to display all of the columns from each record in the datatable based upon the date range and all of the values selected in the ListBox. (This is a daily sales tool with columns that sum currency and customer interactions for a retail sales biz)

So if i select 2 Stores and a Date range I currenlty only get the last recordset that was selected from the listbox to display in the datatable.

I have been banging my head against the wall on this trying 'ForAll', "Concat', 'Collect' and more but i am still too new at this to get the order, syntax and placement right.

Any help would be appreciated!

Categories:

Building Power Apps

Hi @ElvisPSherman ,

You are correct in that this is not simple with a many-to-one filter (I assume the Store field is not multi-select or this would be different again as many-to-many) - try this

With(
 {
 wDates:
 Filter(
 'DataSetName',
 Date >= DatePicker1.SelectedDate &&
 Date <= DatePicker2.SelectedDate
 )
 },
 Ungroup(
 ForAll(
 ListBox1.SelectedItems As aList,
 Filter(
 wDates,
 Store.Value = aList.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