Share
Report
338I have three tables: Frameworks (have many) Categories (have many) Subcategories. In the Subcategories table, I want to view the concatenation 'Framework, Category' in the dropdown for Category (see screenshot below).
I have previously posted this problem as two separate questions, but I realize I want to be able to do both:
- The answer to Is there an equivalent of SQL Views in PowerPages to view data across multiple tables? was: Using Dataverse views you can only see the primary table + parent tables data. If you need something more advanced, you will need to build your query using WebAPI or Fetch and to a custom render of the results
- The answer to Is it possible to change the field displayed in a dropdown in a data table? was: Use a Workflow, Plugin, Flow (flow only if it does not need to show up immediately - as it has no real-time option), if it only needs to occur via the user interface you can use JavaScript
Since I want the data to be displayed real-time in the Dataverse table, the above answers suggest four possible ways of doing this:
- WebAPI
- Fetch
- Workflow
- Plugin
Since this is such a common requirement in any application, I'm hoping someone might might be able to suggest the easiest method.
Categories:
All responses (
Answers (
