How to Implement Dependent Dropdowns with Distinct Values from a Non-Persistable Entity in a DataGrid?
0
Hello, I'm working on a use case where I have a non-persistable entity called WorkerDetails. A microflow fetches a list of WorkerDetails using Execute Parameterized Query, and this list is displayed in a DataGrid with the microflow as its data source. I want to add New and Edit buttons to this DataGrid, and in the corresponding forms, I need to implement dependent dropdowns for attributes of WorkerDetails (e.g., Department, Role, Location). Each dropdown should only show distinct values of its respective attribute from the list returned by the microflow. Challenges: Since WorkerDetails is non-persistable, I can't use XPath to directly fetch distinct values. The dropdowns need to be dependent, i.e., selecting a Department should filter the available Roles and so on. The list of WorkerDetails is user-specific, which is why I chose a non-persistable entity to avoid persisting data unnecessarily. Question: Is there a recommended way to implement this kind of dependent dropdown logic using non-persistable entities? Or is there an alternative approach that supports user-specific data while still allowing distinct value filtering and dropdown dependencies? Thanks in advance!