Hello,
I have a dropdown list in my app that displays the distinct values from a collection. The collection simply takes the values from a SQL database.
Some users have noted that they can find some rows (we are searching by BatchName) only with the search bar, but the same BatchName is not shown in the dropdown list. See the example below with batch Pilot Plus_07072021_Addition: we can see the two records associated to that batch in the gallery below by entering the batch name in the search bar, but the batch will not show anywhere in the dropdown list.
This is the code for my Screen | OnVisible property:
ClearCollect(collectBatches, {Result: "All"});
Collect(
collectBatches,
Distinct('[dbo].[JourneyUser]', BatchName)
)
And my dropdown simply calls the collection in the Items property:
collectBatches
Any suggestions? This is very important as any other function in the app works with the list in the dropdown.
Thanks in advance!
~Alienvolm
