cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IsaiahA
Level: Powered On

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
DaveB
Level: Powered On

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.

Community Support Team
Community Support Team

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.
DaveB
Level: Powered On

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.

PowerApps Staff Vijeta
PowerApps Staff

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

 

 

 

Community Support Team
Community Support Team

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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 49 members 4,230 guests
Please welcome our newest community members: