Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Filtered lookups - "Users can turn off filter" checked, but does not seem to work

(0) ShareShare
ReportReport
Posted on by 30

If I check the "Users can turn off filter" on a filtered lookup field on a form, the functionality isn't working in Unified Interface - it allows me to nominally 'Change View' to e.g. All Active, but then returns no records for me to select or search in.

The same field on the same form works as it used to on classic web interface - User can correctly uncheck 'filter by related..' in the Lookup Record dialogue.

Is this a longstanding recognised issue does anyone know?  Thanks!

  • BeckF Profile Picture
    BeckF 30 on at
    RE: Filtered lookups - "Users can turn off filter" checked, but does not seem to work

    Thanks for that Henry, appreciated!

  • Verified answer
    Henry J. Profile Picture
    Henry J. 5,237 on at
    RE: Filtered lookups - "Users can turn off filter" checked, but does not seem to work

    Hello Beck,

    I'm still around :)

    This is currently a feature gap our product team has identified and are working on.
    In the meantime, you can use the classic designer to toggle that option.

    Henry

  • BeckF Profile Picture
    BeckF 30 on at
    RE: Filtered lookups - "Users can turn off filter" checked, but does not seem to work

    Hi Henry, if you are still there hope you're well!  I apologise I never saw this response back in 2019.  It was the ability for users to turn off the filter I was missing from lookups on the new UI forms, but it appears this was added 6 months later (a year ago now!) according to the next relevant blog: https://powerapps.microsoft.com/en-us/blog/lookup-filtering-enhancements-in-unified-interface/ and now works great for the end user in the new UI.

    However, revisiting this on a different project, during build in make.powerapps.com form designer I noticed on an existing lookup field that I can't see where in the properties you would set this 'User can turn off' option (can't see an equivalent Related Records filtering section), so I had to go back to classic to do this.  Do you know if this is an identified gap in the new form designer, or is it me missing something somewhere?  Screenshots below.  Many thanks! 

    classiclookupproperties.jpgnewUIlookupproperties.jpg

  • Suggested answer
    Henry J. Profile Picture
    Henry J. 5,237 on at
    RE: Filtered lookups - "Users can turn off filter" checked, but does not seem to work

    Hi Beck,

    There was a similar issue in that thread, would that solve your issue? 
    https://community.dynamics.com/365/unified-interface/f/unified-interface-forum/364636/filtered-lookup-not-working-in-ui-model-driven-app

    Because Filtered Lookups are supposed to work properly.

    Also, have you enabled Early Access to the Release Wave 2 (it's going to be all enabled on all orgs during the month of October for those who haven't enabled it yet).
    https://docs.microsoft.com/en-us/power-platform/admin/preview-october-2019-updates
    This comes with enhancements on how Lookup work:
    https://powerapps.microsoft.com/en-us/blog/preview-for-usability-enhancements-to-lookups-in-unified-interface/

    Henry

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans