Hi @SalemB ,
Could you please share a bit more about the Available column in your SP list? Is it a Number type column?
Do you want to filter your Data Table records based on the selected values within your two List Box controls?
I assume that the Available column is Number type column in your SP list, and Available column = 1, means that the corresponding PC is available, Available column = 0, means that the corresponding PC has been loaded. And the Manufacturer column is a Single line of text type column in your SP list.
I have made a test on my side, please take a try with the following workaround:
Set the Items property of the ListBox1 to following:
["Microsoft", "HP", "Lenovo", "Dell"]
Set the Items property of the ListBox2 to following:
["Available", "Loaded"]
Set the Items property of the Data Table control to following:
Filter(
'20181019_case9_Courses',
If(
!IsEmpty(ListBox1.SelectedItems),
Manufacturer in ListBox1.SelectedItems.Value,
true
)
)
On your side, you should type the following formula:
Filter(
'YourSPList',
If(
!IsEmpty(ListBox1.SelectedItems),
Manufacturer in ListBox1.SelectedItems.Value,
true
),
If(
!IsEmpty(ListBox2.SelectedItems),
Available in AddColumns(RenameColumns(ListBox2.SelectedItems,"Value","TextValue"),"NumberValue",If(TextValue = "Available", 1, 0)).NumberValue,
true
)
)
Above formula may cause a Delegation warning issue, if you want to get rid of this warning issue, please check the following workaround:
Set the OnVisible property of the first screen of your app to following:
ClearCollect(RecordsCollection, 'YourSPList')
Set the Items property of the Data Table control to following:
Filter(
RecordsCollection,
If(
!IsEmpty(ListBox1.SelectedItems),
Manufacturer in ListBox1.SelectedItems.Value,
true
),
If(
!IsEmpty(ListBox2.SelectedItems),
Available in AddColumns(RenameColumns(ListBox2.SelectedItems,"Value","TextValue"),"NumberValue",If(TextValue = "Available", 1, 0)).NumberValue,
true
)
)
Best regards,
