Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

WARNING - New Analysis Engine Has Bugs

(0) ShareShare
ReportReport
Posted on by 60
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:
  • RobDin Profile Picture
    RobDin 60 on at
    WARNING - New Analysis Engine Has Bugs
    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.
     
  • ANB Profile Picture
    ANB 7,065 on at
    WARNING - New Analysis Engine Has Bugs
    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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard