Share
ReportI am currently working on a component for Dynamics 365 Sales using the Power App Component Framework. I am at the stage where I have my design completed, but now need a way to display the data. I have two tables as follows (one-to-many relationship):
Lead (Default Entity)
Visit (Custom Entity)
- Lookup called "new_new_parent_leadid" (relationship)
- DateCreated
- Duration
- Value
What Id like to do is query data from Visits table from a component on the Lead form. This component would display the following:
- Count: Count of all related visits
- Latest Visit: DateCreated of the latest related record
- Total Duration: Sum of all Durations of related visits
- Value: Average of value of related visits
How might I retrieve this data?
Categories:
All responses (
Answers (
342
