Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Opportunity Quick Find search shows error SQL Server Error

(0) ShareShare
ReportReport
Posted on by 28,959 Super User 2024 Season 1

Hello,

Quick find search not working on Oppiortunity entity. It shows SQL Server Error.

Opportunity-Quick-Search-Error.PNG

  • Henry J. Profile Picture
    Henry J. 5,237 on at
    RE: Opportunity Quick Find search shows error SQL Server Error

    Good call. I would add that it's actually a best practice to leave that option enabled (it's on by default.)
    https://docs.microsoft.com/en-us/power-platform/admin/settings-features#settings

  • Verified answer
    Bipin D365 Profile Picture
    Bipin D365 28,959 Super User 2024 Season 1 on at
    RE: Opportunity Quick Find search shows error SQL Server Error

    This is fixed by changing below system settings in our instance.

    enable Quick Find record limit in your affected instance in order to mitigate this issue. In order to do this, navigate to Settings -> Administration -> System Settings. Under General tab, set “Enable Quick Find record limits” to yes.

  • Verified answer
    Henry J. Profile Picture
    Henry J. 5,237 on at
    RE: Opportunity Quick Find search shows error SQL Server Error

    Hello,

    I'm not sure this is related to the Unified Interface. Is this working in the legacy web client?

    For this type of error, I would open a Support Request here: admin.powerplatform.microsoft.com/support

    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 Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,514 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans