I have created an Inventory system app where data source is SharePoint. I am using Table layout to fetch the SharePoint list.
There is a Lookup field named Audience is created which has blank cells as well. My issue is when I am publishing the app, the data having Audience field is not loading in the table(Data is present and searchable but not showing up when loading the app). Also, when I am sorting the columns, the table is showing duplicate results(Example- List has 40 items but in PowerApps its showing 160 items). However, when I am searching the data, I am getting correct results. Not sure what is wrong I am doing here. Below is the code I have written on items property of Table
If(
DropdownCanvas1_1.Selected.Value = "Business Line",
Sort(
Filter(
Filter(
'Inventory List',
'Business Line' in DropdownCanvas2_1.SelectedItems || IsBlank(DropdownCanvas2_1.Selected.Value),
'Created By'.DisplayName = ComboboxCanvas1_1.Selected.Value || IsBlank(ComboboxCanvas1_1.Selected.Value),
And(
Or(
IsBlank(DatePickerCanvas1_1.SelectedDate),
DateValue(Created) >= DatePickerCanvas1_1.SelectedDate
),
Or(
IsBlank(DatePickerCanvas2_1.SelectedDate),
DateValue(Created) <= DatePickerCanvas2_1.SelectedDate
)
),
Audience in ComboboxCanvas2.SelectedItems || IsBlank(ComboboxCanvas2.Selected.Value)
),
TextInputCanvas1.Value in 'Inventory Code' || TextInputCanvas1.Value in 'Business Line'.Value || TextInputCanvas1.Value in Audience.Value
),
'Business Line'.Value,
If(
sortDirAsc,
SortOrder.Ascending,
SortOrder.Descending
)
),
If(
DropdownCanvas1_1.Selected.Value = "Created",
Sort(
Filter(
Filter(
'Inventory List',
'Business Line' in DropdownCanvas2_1.SelectedItems || IsBlank(DropdownCanvas2_1.Selected.Value),
'Created By'.DisplayName = ComboboxCanvas1_1.Selected.Value || IsBlank(ComboboxCanvas1_1.Selected.Value),
And(
Or(
IsBlank(DatePickerCanvas1_1.SelectedDate),
DateValue(Created) >= DatePickerCanvas1_1.SelectedDate
),
Or(
IsBlank(DatePickerCanvas2_1.SelectedDate),
DateValue(Created) <= DatePickerCanvas2_1.SelectedDate
)
),
Audience in ComboboxCanvas2.SelectedItems || IsBlank(ComboboxCanvas2.Selected.Value)
),
TextInputCanvas1.Value in 'Inventory Code' || TextInputCanvas1.Value in 'Business Line'.Value || TextInputCanvas1.Value in Audience.Value
),
"Created",
If(
sortDirAsc,
SortOrder.Ascending,
SortOrder.Descending
)
)
,If(
DropdownCanvas1_1.Selected.Value = "Audience",
Sort(
Filter(
Filter(
'Inventory List',
'Business Line' in DropdownCanvas2_1.SelectedItems || IsBlank(DropdownCanvas2_1.Selected.Value),
'Created By'.DisplayName = ComboboxCanvas1_1.Selected.Value || IsBlank(ComboboxCanvas1_1.Selected.Value),
And(
Or(
IsBlank(DatePickerCanvas1_1.SelectedDate),
DateValue(Created) >= DatePickerCanvas1_1.SelectedDate
),
Or(
IsBlank(DatePickerCanvas2_1.SelectedDate),
DateValue(Created) <= DatePickerCanvas2_1.SelectedDate
)
),
Audience in ComboboxCanvas2.SelectedItems || IsBlank(ComboboxCanvas2.Selected.Value)
),
TextInputCanvas1.Value in 'Inventory Code' || TextInputCanvas1.Value in 'Business Line'.Value || TextInputCanvas1.Value in Audience.Value
),Audience.Value,If(
sortDirAsc,
SortOrder.Ascending,
SortOrder.Descending
)
)
)))
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473