cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Advocate II
Advocate II

Re: Unable to find a data type

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.

Highlighted
Community Support
Community Support

Re: Unable to find a data type

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.
Highlighted
Advocate II
Advocate II

Re: Unable to find a data type

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.

Highlighted
Power Apps
Power Apps

Re: Unable to find a data type

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

 

 

 

Highlighted
Community Support
Community Support

Re: Unable to find a data type

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
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,839)