The following worked:
The query type (click
) needed to be set to List of Documents in stead of single document (which was what I did wrong).
Then the Marker type (click
) needed to be set to LatLng and Set from Variable is set to the Collection, with available options set to Map List Items and then the column 'Location' which had the latitudes and longitudes.