cannot use lookup to make relation with standard CDS entity Address

%3CLINGO-SUB%20id%3D%22lingo-sub-1461678%22%20slang%3D%22en-US%22%3Ecannot%20use%20lookup%20to%20make%20relation%20with%20standard%20CDS%20entity%20Address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1461678%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAim%20is%20to%20make%20a%20canvas%20Power%20App%20based%20on%20CDS.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20made%20a%20new%20entity%20and%20added%20field%20to%20it.%20All%20well.%20I%20then%20need%20a%20field%20to%20store%20the%20lat%20and%20Lon%20coordinates%20of%20a%20location.%20So%20I%20wanted%20to%20use%20a%20lookup%20to%20the%20standard%20entity%20'Address'%20%2C%20which%20already%20has%20the%20field%20Latitude%20and%20Longitude.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20I%20make%20the%20new%20field%20StartLocation%20and%20I%20set%20the%20data%20type%20to%20lookup%2C%20Address%20does%20not%20show%20up%20in%20the%20list%20of%20related%20entities%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20should%20I%20do%20to%20get%20a%20lookup%20to%20Address%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOf%20course%20I%20could%20make%20two%20other%20fields%20like%20latitude%20and%20longitude%20to%20store%20the%20values%2C%20but%20I%20would%20like%20to%20use%20the%20Address%20entity%20so%20I%20could%20later%20enrich%20it%20with%20other%20values.%2C%20e.g.%20get%20the%20street%20and%20postal%20code%20data%20from%20a%20Bingmap%20API%20call.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1461678%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi,

 

Aim is to make a canvas Power App based on CDS. 

 

I made a new entity and added field to it. All well. I then need a field to store the lat and Lon coordinates of a location. So I wanted to use a lookup to the standard entity 'Address' , which already has the field Latitude and Longitude. 

 

But when I make the new field StartLocation and I set the data type to lookup, Address does not show up in the list of related entities ...

 

What should I do to get a lookup to Address? 

 

Of course I could make two other fields like latitude and longitude to store the values, but I would like to use the Address entity so I could later enrich it with other values., e.g. get the street and postal code data from a Bingmap API call.

0 Replies