
Announcements
I'd like to show lat/long data from the Functional Locations table as well as some info from Projects (a relationship was added) in my geospatial map fields on a Canvas app.
I've tried using a view that filtered the Project rows and also linked the Functional Location entity but I can't get to the msdyn_functionallocation fields.
I've tried using Functional Locations for the Items and using dot notation get to the Project as shown in some articles I read (but they weren't using the map). I wasn't able to get that to work.
What is the best approach to using fields from related tables (entities) with a geospatial map in a Canvas App?
My current fallback thought is create a spreadsheet every few hours that the app uses as a data source with the 'flattened' data. But I would prefer to go against the tables directly.
Any assistance is appreciated.