web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Unable to find a data ...
Power Apps
Unanswered

Unable to find a data type

(0) ShareShare
ReportReport
Posted on by IsaiahA 75

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.

Categories:
Building Power Apps
I have the same question (0)
  • DaveB Profile Picture
    DaveB 96 on at

    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 Profile Picture
    v-micsh-msft Microsoft Employee on at

    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

  • DaveB Profile Picture
    DaveB 96 on at

    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.

  • Vijeta Profile Picture
    Vijeta Microsoft Employee on at

    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

     

     

     

  • v-micsh-msft Profile Picture
    v-micsh-msft Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 177

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans