the goal of the project is to develop a dog tracking app. the telemetry data is being push to a googlesheet then we need to show the latest location in the application.
i have the following formula to select the most recent row from the sheet.
LOOKUP( MAX(dogtracker1[_ROWNUMBER]), “dogtracker1”, “_ROWNUMBER”, “latlong” )
i can see that this selects the last row but the maps, ref details and forms do not update with the latest data. Is there a way to select the the latest telemetry data than display only that last know location based on the last row ?