I have a canvas app that queries a table of license plate reads from our gate control system in order to determine the number of gates and their names at our facility. When I execute the following ClearCollect to get a collection of gate names it always returns one row instead of three:
The behavior I'm concerned about is a change in results from this ClearCollect. Prior to turning on the new analysis engine I get three results (Gate 1, Gate 2, Gate 3). After turning it on, with no changes in my code, it now only puts Gate 1 in the Gates collection. This would mean the countdown to the new analysis engine being turned on by default is a countdown for users not being able to select Gate 2 and Gate 3 as soon as it is turned on.
It wouldn't be so bad if I could simply turn it off, but in the announcement thread they said the new analysis engine will be the only option in the future.
The code that you are using is straight forward. And I am sure that you know the Distinct function: The Distinct function in PowerApps removes duplicates from a table's records. It evaluates a formula for each record in the table and returns a one-column table of the results. The syntax is Distinct(Table, Formula)
So, just wanted to confirm that does your data source has 3 unique records?
Please share few screenshot.
Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
Thanks,
ANB
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.