web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : smw7daJJRXHwPRtsLXpHfo
Power Apps - Building Power Apps
Unanswered

When loading SharePoint list data to PowerApps(Table layout) getting duplicate results/Lookup field having blank values are not loading

Like (0) ShareShare
ReportReport
Posted on 7 Jun 2024 23:05:50 by

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
)
)
)))

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473