Thomas Vieil Tech Lead

TLDR: Add support for ALL hierarchical operators in the Query Editor

Hierarchies is a data modeling feature that is both powerful and elegant.

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/query-hierarchical-data

Frustratingly, the Query Editor User Interface (UI) used for building dynamic lists (or saved queries) only supports a couple of the hierarchical operators. Currently, when the selected attribute is a primary key, only "under" and "not under" are present among all operators in the drop down list. Other operators such as "above" are missing.

The proposition is to show ALL the hierarchical when the selected attribute is the primary key (of a table with explicit hierarchical relationships).

For our most challenging surveys, we want to make it possible to take a survey on behalf of the customer, while on the phone or in a meeting with the customer:

• Showing an invitation on the user's screen to initiate the response registration process.
• Allow the user to link the responses to the correct contact/account record
• Provide a simple way to archive or share the responses with the customer (as a read-only PDF)

For regulated surveys, we need a way to archive the customer's responses and possibly share them with the customer or the regulation authorities. PDF file storage would be the preferred format.