Hi guys
I've got the strangest issue. I have a PowerApps screen with a few comboboxes. The comboboxes all use the Distinct() function to get values from a SharePoint list without duplicates. All the comboboxes work. The columns I am looking up in SharePoint are all Single line of Text. My SharePoint list is called 'Items to Action'.
Distinct('Items to Action',TypeDisplay)Distinct('Items to Action',EmployeeName)Distinct('Items to Action',EmployeeNumber)
I decided to filter the results a bit further based on the signed in user, so I added a filter to the datasource part of the Distinct function based on a Person or Group column called "AreaManager":
Filter('Leave to Action',User().FullName = AreaManager.DisplayName)
Which looks like this when I apply it:
Distinct(Filter('Leave to Action',User().FullName = AreaManager.DisplayName),TypeDisplay)Distinct(Filter('Leave to Action',User().FullName = AreaManager.DisplayName),EmployeeName)Distinct(Filter('Leave to Action',User().FullName = AreaManager.DisplayName),EmployeeNumber)
What I find so strange is that the TypeDisplay combobox continues to work, but the EmployeeName and EmployeeNumber comboboxes stop working.
I also perfomed a test where I compared the signed in person to the author field (a.k.a. Created By) and all 3 of the comboboxes work:
Distinct(Filter('Leave to Action',User().FullName = Author.DisplayName),TypeDisplay)Distinct(Filter('Leave to Action',User().FullName = Author.DisplayName),EmployeeName)Distinct(Filter(Filter('Leave to Action',User().FullName = Author.DisplayName),EmployeeNumber)
Any idea why this would be?
The list does not return a lot of items and the 500 item limit will not be reached and I have upped this value to 2000 items under App Settings in any case.
Any suggestions would be great. This has been doing my head in!
