en en en de en en en da da it da it da da es en da da en da da de da da da sv da en da en en en da pt fr fr de sv da da sv da da en ca en en en nl en en en en en en en en en en en en en en da da da tr da en en en en en en en en en ca en en lt en en en en en en en kn da en en nl nl da en da de de en en nl en en nl nl sv en da de de en en nl en en nl nl sv en da de de en en nl en en sv nl da en da de da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da de de en en de da da en en da da en da ms en en en en sv da fr da da en en en zh da de en en en en it en da da en da da da
Multi-table lookups now available! (Preview) | Microsoft Power Apps
Ressourcer til markedslanceringstjenester til partner
Multi-table lookups now available! (Preview)
Nathan Helgren, , 6. juli 2021
Multi-table lookups, a long awaited and much requested feature, are now live (Preview) for use via API. Multi-table lookups (also sometimes known as polymorphic lookups) allow te creation of a lookup in one table that looks up records in multiple other tables at once. This provides much greater flexibility in retrieving data within your environments.
Imagine you are trying to create a lookup that lets you check out media to users. You have a table of Books, a table of Audio offerings, and a table of Video offerings. Prior to this, there was no easy way to create a lookup that would pull data from all three tables at once, and you may end up with three separate lookups:
What if you were searching for both te physical book and audio book for a title you wanted?  What if you wanted to find te soundtrack to a movie and a movie? What if a friend recommended a movie to you but also said te book was great? Looking this data up across multiple tables would require individual lookups, require you to search and populate shared IDs into your checkout table, or write a custom solution.
With multi-table lookups, you can perform a lookup on 2 or more tables at te same time and locate te record you want from te referenced tables. These lookups are all  1 to many relationships and will work in a similar way as te Customer lookup that is built into Dataverse, where Customer look ups search both Account and Contact.
Using these multi-table lookups can reduce development time for your apps and provide a more streamlined user interface. For te current preview:
Lookups can be constructed and managed through API only
Model driven apps currently provide te best experience with te lookups
Maker UI support for creation and management is coming soon, and improved canvas app support is planned for te future.
To learn more about multi-table lookups please see te following document:
Use multi-table lookup columns (Microsoft Dataverse) – Power Apps | Microsoft Docs
Hvad er Power Apps?
Power Apps er en tjeneste til oprettelse og brug af brugerdefinerede virksomhedsapps, der opretter forbindelse til dine data og fungerer på tværs af nettet og mobil – uden at du skal bruge tid og penge på brugertilpasset softwareudvikling.
Application Lifecycle Management (ALM)
Power Platform Admin Center
Lad os komme i gang
Angiv din arbejds- eller skolekonto for at komme i gang.
Når du tilmelder dig, accepterer du servicebetingelserne.
Erklæring om beskyttelse af personlige oplysninger
Beskyttelse af personlige oplysninger og cookies
čeština dansk Deutsch (Österreich) Deutsch (Schweiz) Deutsch (Deutschland) Eλλnvιkά English (Australia) English (Canada) English (Cyprus) English (UK) English (Ireland) English (India) English (Malaysia) English (New Zealand) English (Singapore) English (US) English (South Africa) español (España) español (México) français (Belgique) français (Canada) français (Suisse) français (France) suomi magyar italiano (Svizzera) italiano (Italia) 日本語 한국어 norsk bokmål Nederlands (België) Nederlands (Nederland) polski português (Brasil) português (Portugal) pycckий svenska ไทย Türkçe 中文(简体) 中文(繁體) العربية עברית