Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Suggested answer

Bug in Advanced Find - showing wrong list of fields in related table filter

(0) ShareShare
ReportReport
Posted on by 48
In Advanced Find in the modern UI (new look),
  1. Create an AF query on any table (Account for example)
  2. Add a related table (ex: Currency)
  3. Add two filter fields (ex: created by and created on)
  4. Group them together
  5. Add a 3rd filter field to the group created in step 4 - NOTE that the list of fields is from the parent (account) table, not the currency table.
Workaround
At step #3, add all your filter fields there before grouping them, or ungroup them to add the fields, and re-group them when you are done. 
 
I am using 2024 Release Wave 1, Server version: 9.2.24082.00192, Client version: 1.4.9104-2408.2
Given that this is just a minor platform bug (not a security issue), is there a better place to post this where someone at Microsoft Dynamics team will get it?
Categories:
  • Suggested answer
    ankit_singhal Profile Picture
    ankit_singhal 377 on at
    Bug in Advanced Find - showing wrong list of fields in related table filter
    Hi,

    I think there is some issue with grouping. MS introduced grouping in power app grid control as well but we faced many issue and reported to MS, now MS said they will rollback this feature and will introduce again in Wave 1 2025 

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,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics