How to query hierachy data using advanced find?

(1) Share

Report

Posted on by Sandra Soniec

128

Hi community,

In my business scenario, I need to deal with hierachy data. I have built a custom entity, the one-to-many relationship and enabled hierachy settings, sample data in. Started exploring with advanced find but couldn't find the "under / not under" commands (as suggested in the microsoft docs) to query from root node over all children. Is fetchXML needed to this task? Directions welcome!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (2)

v-jefferni on at

Like (1)

Report

Hi @SandraSoniec ,

Sorry for the delay.

For your question, it could be a little difficult to get an answer here in PowerApps forum, I recommend you to search in the Dynamics365 forum since there might be similar scenarios and solutions of them:
https://community.dynamics.com/

However, I have found some threads or blogs which look could be helpful:
https://softnovation.wordpress.com/2017/07/30/query-hierarchical-data/
https://docs.snowflake.com/en/user-guide/queries-hierarchical.html

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Verified answer

Summit Bajracharya on at

Like (1)

Report

With model driven, It's not possible. But you can create a Canvas based PowerApps and have it embed in the Model Driven app. Or create a webresource that achieves what you are expecting.

Was this reply helpful? Yes No
Sandra Soniec 128 on at

Like (0)

Report

@summitb Thanks directions. Will use embedded canvas approach for now. Web resources appears to be useful for my app too.

Was this reply helpful? Yes No
summitb on at

Like (1)

Report

Glad to have helped you with solution @SandraSoniec

Was this reply helpful? Yes No
Verified answer

Sandra Soniec 128 on at

Like (0)

Report

@v-jefferni and @summitb FYI further tested out advanced find.
If the entity contains one-to many self-references defined as hierarchy relationship you can select the Unique ID of a record and use the "above" or "under" operator in the condition to find all ancestors or children.

Further information can be found here
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/query-hierarchical-data#condition-operators-for-hierarchical-data

Was this reply helpful? Yes No