Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Dataverse SEARCH does not return rows in a managed solution, row count = 0

(0) ShareShare
ReportReport
Posted on by 4

I have a power virtual agent solution connected to Omnichannel that calls a flow to do  a search and row count is always zero. This works in an unmanaged solution in dev but When I import and export to the Prod environment this is where I am having the problem. I tested this with the core table and quick find search isn't returning any matches in the managed solution.  I can see in the flow It is finding the table  but the search is always zero.  I am thinking it is security related but for testing purposes I am system Admin for the environment. Indexes have been deprovisioned and rebuilt, but the results are the same. I also tested with the Dataverse table attached to the solution and as well as adding and populating outside a solution.

 

Thanks,

LL

  • Verified answer
    MicaelLev Profile Picture
    MicaelLev 28 on at
    Re: Dataverse SEARCH does not return rows in a managed solution, row count = 0

    Experiencing also problems with Dataverse Search. Your flow uses the Dataverse service and for my part it is the indexing part that is buggy. Here is what I have found and how i am able to fix it temporarly : 

    1. The scenario is to deploy a managed solution into another sandbox environment, with quick find views configured.
    2. The Dataverse Search index is turned on.
    3. After deployin, the index columns from the table in question does not change. I suspect Importing managed solution does not update Dataverse Search index.

    To fix it : 

    1. Add a dumb unmanaged solution beside
    2. Add the table and include only the quick view
    3. Update the view by faking a change by addind another column or watever. Save and publish
    4. In dataverse Search indexing, look at column number, It should have changed now and thus Dataverse indexing will start after a few minutes
    5. Results start to come out.

    So, the problem with this scenario is after each "override solution configuration import", the changes will be lost and Dataverse reverts to default index. I have to follow again the described solution...

  • ChrisPiasecki Profile Picture
    ChrisPiasecki 6,389 on at
    Re: Dataverse SEARCH does not return rows in a managed solution, row count = 0

    Hi @Larry2,

     

    I haven't worked on a GCC environment before so I won't be able to provide much insight specificly around it. That said, the documentation does mention for US Gov environments to enable tables for search in the classic solution explorer:

     

    If you are selecting tables for Dataverse search on a Power Apps US Government environment, use the legacy solution explorer to choose the tables to be indexed for Dataverse search.

     

    Have you tried doing it via this method? If that doesn't help, I'd suggest raising a ticket with Microsoft support since they advised you that it was safe to use it in prod even though it's still preview in GCC. 

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

  • Larry2 Profile Picture
    Larry2 4 on at
    Re: Dataverse SEARCH does not return rows in a managed solution, row count = 0

    All that was verified.  I read there were some bugs in Release wave 2 with Quick find in commercial. I am running in GCC. It is working fine as unmanaged code in the dev environment. Not sure if it is related to GCC. The dataverse search is still in preview but works fine in dev GCC and Microsoft said it was OK to go to Prod with the dataverse search.

  • ChrisPiasecki Profile Picture
    ChrisPiasecki 6,389 on at
    Re: Dataverse SEARCH does not return rows in a managed solution, row count = 0

    Hi @Larry2,

     

    In the target environment where the managed solution is deployed, you confirmed that Dataverse Search is enabled in the environment settings (via Admin Center), and the table is search enabled?

    Also, check on each table the managed property can enable sync to external search index is set to true.  Note that any changes to the search index may take several minutes to several hours to sync data depending on the volume of data. 

     

    The Search Rows in your flow will run under whatever account you've set on the connection, so the search results will be filtered based on that connection users security privileges in the environment. Make sure that user has necessary read privileges to your tables to see the expected records. 

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

     

     

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics