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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,254)