cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IsaiahA
Advocate III
Advocate III

Unable to find a data type

Hi:

 

In designing my entities, I could not find the following data types (from available drop down list) for a field:

1. Lookup

2. Currency

 

Could someone advise me on where to look for the above mentioned data type? 

 

I would appreciate your quick response.

 

Isaiah A.

5 REPLIES 5
DaveB
Advocate II
Advocate II

Lookup type is available in legacy CDM migrated databases only, in new environments and CDS your entities have relationships now (see the tabs when designing an entity). The currency data type shows as an option in both versions for me.

v-micsh-msft
Community Support
Community Support

Hi IsaiahA,

 

In my testing, I could find the Currency and the Lookup Data type:

36.PNG

 

If you need any further help on this, please post back.

 

Edited: Removed the old articles.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Michael_Shao, the 'Lookup' data type cannot be chosen in new CDS databases, it is only available in the legacy migrated environment databases. You cannot find 'Lookup' data type in the dropdown in new environment databases.

Hello,

Please create a lookup relation in the relationship tab for the entity in the new environment. It will automaticaly create a lookup field for you.

Thanks

 

 

 

Hi DaveB,

Thanks for the remidings, I checked in the wrong environments. Apologizes.

In the new environment, the lookup type could be managed under the newly created entites, click into the entity, under relationship tab, click new relationship:

38.PNG

The currency is still listed under the fields.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,518)