Aktuelle News aus der Microsoft Dynamics Welt und von TSO-DATA
Aktuelle News aus der Microsoft Dynamics Welt und von TSO-DATA
Aktuelle News aus der Microsoft Dynamics Welt und von TSO-DATA
14.07.2021

Power Apps: Multi-table lookups now available

[Translate to English:]

Power Apps is a service for developing and using custom business applications/apps that connect to your data and can be used on both the web and mobile devices. It significantly minimises the time and cost normally associated with custom software development.

Multi-table lookups (sometimes referred to as polymorphic lookups) allow you to create a lookup in one table that searches records in several other tables simultaneously. This provides much greater flexibility when retrieving data in your environments.

For example, a use case would be if you wanted to create a lookup to check out media for users. You have a table of books, a table of audio offerings and a table of video offerings. Previously, there was no easy way to create a lookup that retrieves data from all three tables at once, and you might end up with three separate lookups:

  • Borrow -> Books
  • Borrow -> Audio
  • Borrow -> Video

But now you may be looking for both the physical book and the audio book for a particular title. Or for the soundtrack to a film and the film itself. Or when a friend recommends a film to you, and also mentions that the book is great.

Looking up this data in multiple tables requires individual lookups, finding and inserting common IDs into your checkout table, or writing a custom solution.

When searching multiple tables, you can perform a search on two or more tables at the same time and find the record you want from the referenced tables. These searches are all 1:n relationships and work similarly to Dataverse's built-in customer search, where customer searches look for both account and contact.

For more info, see the Microsoft blog.

Do you have questions about the new functions? Our Dynamics 365 experts will be happy to assist you personally.

 

TSO-DATA
David Eggenhofer
dynamics365[at]tso[dot]de
+49 (541) 1395-707


More news and events - you might also be interested:

M-Files: new desktop client even more user-friendly

M-Files: new desktop client even more user-friendly

The M-Files document and information management system has been given a new user interface, which makes it even more intuitive to use and thus significantly simplified.

continue reading...
Avoid fines - with the GDPR ToolBox

Avoid fines - with the GDPR ToolBox

Make personal data from your Microsoft ERP system available on demand quickly and reliably with our GDPR ToolBox to avoid high fine demands.

continue reading...
Freeze-Dry Foods combines document management and ERP system

Case Study: Freeze-Dry Foods combines document management and ERP system

To optimize digital processes and increase efficiency, Freeze-Dry Foods decided to use the document and information management system M-Files, which can be seamlessly integrated into the existing ERP system using TSO-DATA's DMS Connector.

continue reading...