web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / search a value in all ...
Power Apps
Unanswered

search a value in all tables

(0) ShareShare
ReportReport
Posted on by 465

Hi all

there is a way to find a value in all tables of a dataverse database?
thanks for any suggestion

  • Ami K Profile Picture
    15,689 Super User 2024 Season 1 on at

    Hi @diepic ,

     

    Yes you can do this via Dataverse Search.

     

    Amik_0-1686156388188.png

     

    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/relevance-search 

     

    https://learn.microsoft.com/en-us/power-apps/user/relevance-search

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

     

  • DiePic Profile Picture
    465 on at

    Thanks a lot @Amik , but I'm not administrator of the tenant and I cannot activate this option.

    There are other ways to find my value, XrmToolBox or other?

    ....

    Can you say me where are registered the "notes of leads" (Dynamics 365 Sales) inserted in the timeline?

     

    diepic_0-1686210337952.png

     



  • Ram Prakash Duraisamy Profile Picture
    5,891 Super User 2026 Season 1 on at

    Hi @diepic 

     

    What ever @Amik  said is correct.

  • DiePic Profile Picture
    465 on at

    for notes I find that are stored in table ANNOTATION
    (if can help)

  • DiePic Profile Picture
    465 on at

    thanks @rampprakash but I'm not admin of tenant and I cannot activate that option ....
    I ask if there is other ways to obtain my value, maybe with XrmToolBox or other

  • Ami K Profile Picture
    15,689 Super User 2024 Season 1 on at

    @diepic - Dataverse search is usually turned on by default, can you validate if it is?

     

    If it is not, you do not need to be an admin of the tenant in order to activate it. A System Admin and System Customizer should also be able to activate that toggle.

     

    If you have neither of those roles, I would suggest speaking to someone with the correct security permissions to activate it, before going down the XrmToolbox route.

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

  • Erik Donker Profile Picture
    8 on at

    You can also use the Dataverse Toolbelt https://apps.microsoft.com/store/detail/jm-dataverse-toolbelt/XP8LT89GK8T7RF . This tool has the option to search all (text) tables in an environment for a given value.

  • DiePic Profile Picture
    465 on at

    Hi @EDon 
    There is a problem on Microsoft I suppose, I try all the day but It says that it's not downlodable

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 381 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 340

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard