Unanswered

WARNING - New Analysis Engine Has Bugs

(0) Share

Report

Posted on by RobDin

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:

ClearCollect(Gates,Sort(Distinct(Reads,Location),Value,SortOrder.Ascending));
 
When Microsoft automatically turns on this feature in February it will break the gate control in my app. 
 
MICROSOFT, PLEASE DO NOT ACTIVATE THIS BUGGY FEATURE BY DEFAULT.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RobDin,

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

Was this reply helpful? Yes No
RobDin 69 on at

Like (0)

Report
Copy link

Link copied!

Hi ANB,

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.

Was this reply helpful? Yes No