Neue Funktion: Tabellen vereinigen | Power Apps

Title: How to Merge Tables in Power Apps | Neue Funktion: Tabellen vereinigen | Power Apps

Channel: Kai Weissmann

Description: In this tutorial, I will show you how to merge tables and create combined columns using the updated Table function in Power Apps. Additionally, I will demonstrate how you can filter the merged table.

Steps:

1. Connect Multiple SharePoint Lists with Power Apps

   • Start by opening Power Apps and navigating to the Data section.
   • Click on the option to connect to SharePoint Lists.
   • Follow the prompts to connect and select the lists you want to merge.

2. Merge Tables using the Table Function

   • Use the Table function in Power Apps to merge the connected SharePoint Lists.
   • This function allows you to combine the data from different lists into a single table.

3. Rename and Combine Columns

   • After merging the tables, you can rename columns using the RenameColumns function.
   • Use the AddColumns function to combine columns from the merged tables.

4. Filter the Merged Table

   • Apply filters to the merged table to display specific data.
   • Use the Filter function to refine the data based on your criteria.

5. Additional Resources:

   • Check out more tutorials on:
     • Kataloge & Formulare: https://youtu.be/HosFQAMj9aI
     • Galerie & Formular: https://youtu.be/ysNBn7M7vHY
     • Delegierung: https://youtu.be/HYKKQ8PGacA
     • Abhängige Dropdowns: https://youtu.be/4D92PdBOOIA
     • Tabelle Filtern: https://youtu.be/QtLP5tBKGb0

6. Stay Updated:

   • Subscribe to the newsletter for more tips and updates: https://www.powerappstrainer.de/newsletter
   • Read the blog post for detailed information: https://www.powerappstrainer.de/blog/tabellen-vereinigen

Summary Overview:

• The video demonstrates how to merge tables in Power Apps using the Table function.
• It covers connecting SharePoint Lists, renaming and combining columns, and filtering the merged table.

By following these steps, you can effectively merge tables and manipulate data in Power Apps for your projects.