{"id":10321,"date":"2021-07-05T12:50:36","date_gmt":"2021-07-05T12:50:36","guid":{"rendered":"https:\/\/minova.nl\/?p=10321"},"modified":"2023-05-05T11:42:06","modified_gmt":"2023-05-05T11:42:06","slug":"merge-tables-in-power-apps","status":"publish","type":"post","link":"https:\/\/minova.nl\/en\/tabellen-samenvoegen-in-power-apps\/","title":{"rendered":"Merge tables in Power Apps"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"10321\" class=\"elementor elementor-10321\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3f041d0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3f041d0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9f25703\" data-id=\"9f25703\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c7f0acc elementor-widget elementor-widget-text-editor\" data-id=\"c7f0acc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Tabellen samenvoegen in Power BI kan eenvoudig worden gedaan door de functies voor dat doel in de M- en\/of DAX-taal te gebruiken. Zie de blogpost die ik over dat onderwerp hier heb geschreven. Power Apps biedt deze functies niet, dus moeten we tabellen samenvoegen door gebruik te maken van Power Fx, de taal die gebruikt wordt voor het programmeren in (onder andere) Power Apps.<\/p><p>Hier is een overzicht van de joins in Power Apps en de Power Fx code. De tabellen die in dit voorbeeld worden gebruikt zijn:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-87b4979 elementor-widget elementor-widget-spacer\" data-id=\"87b4979\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f1d94c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f1d94c2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1b2ee16\" data-id=\"1b2ee16\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b197b0b elementor-widget elementor-widget-image\" data-id=\"b197b0b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"600\" height=\"137\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Table1and2.jpg\" class=\"attachment-large size-large wp-image-10323 lazyload\" alt=\"\" data-srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Table1and2.jpg 832w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Table1and2-300x69.jpg 300w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Table1and2-768x175.jpg 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><noscript><img decoding=\"async\" width=\"600\" height=\"137\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Table1and2.jpg\" class=\"attachment-large size-large wp-image-10323 lazyload\" alt=\"\" srcset=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Table1and2.jpg 832w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Table1and2-300x69.jpg 300w, https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Table1and2-768x175.jpg 768w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-346c35e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"346c35e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7fea637\" data-id=\"7fea637\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f1c9073 elementor-widget elementor-widget-text-editor\" data-id=\"f1c9073\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><br><\/p>\n<table style=\"border: none;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"width: 49.25pt; border: solid white 1.0pt; mso-border-themecolor: background1; border-right: none; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-bottom-alt: solid white .5pt; mso-border-bottom-themecolor: background1; background: #4472C4; mso-background-themecolor: accent1; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"66\">\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 1;\"><b><span lang=\"EN-US\" style=\"color: white; mso-themecolor: background1; mso-ansi-language: EN-US;\">Icon<\/span><\/b><\/p>\n<\/td>\n<td style=\"width: 103.5pt; border-top: solid white 1.0pt; mso-border-top-themecolor: background1; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: none; mso-border-top-alt: solid white .5pt; mso-border-bottom-alt: solid white .5pt; background: #4472C4; mso-background-themecolor: accent1; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"138\">\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 1;\"><b><span lang=\"EN-US\" style=\"color: white; mso-themecolor: background1; mso-ansi-language: EN-US;\">M<\/span><\/b><\/p>\n<\/td>\n<td style=\"width: 261.0pt; border: solid white 1.0pt; mso-border-themecolor: background1; border-left: none; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-bottom-alt: solid white .5pt; mso-border-bottom-themecolor: background1; mso-border-right-alt: solid white .5pt; mso-border-right-themecolor: background1; background: #4472C4; mso-background-themecolor: accent1; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"348\">\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 1;\"><b><span lang=\"EN-US\" style=\"color: white; mso-themecolor: background1; mso-ansi-language: EN-US;\">Power Apps Power Fx<\/span><\/b><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 49.25pt; border-top: none; border-left: solid white 1.0pt; mso-border-left-themecolor: background1; border-bottom: solid windowtext 1.0pt; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; mso-border-bottom-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"66\">\n<p><img decoding=\"async\" class=\"lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/LeftOuter.png\" alt=\"\" width=\"76\" height=\"48\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"lazyload\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/LeftOuter.png\" alt=\"\" width=\"76\" height=\"48\"><\/noscript><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\">\n<\/p><\/td>\n<td style=\"width: 103.5pt; border-top: none; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; background: #B4C6E7; mso-background-themecolor: accent1; mso-background-themetint: 102; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"138\">\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">Left Outer<\/span><\/p>\n<\/td>\n<td style=\"width: 261.0pt; border-top: none; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; background: #B4C6E7; mso-background-themecolor: accent1; mso-background-themetint: 102; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"348\">\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">AddColumns(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; Table1,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; &#8220;Value.1&#8221;,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; LookUp(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Title = Table1[@Title],<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2[@Value]<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">)<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 49.25pt; border-top: none; border-left: solid white 1.0pt; mso-border-left-themecolor: background1; border-bottom: solid windowtext 1.0pt; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: windowtext; mso-border-left-alt: white; mso-border-bottom-alt: windowtext; mso-border-right-alt: white; mso-border-style-alt: solid; mso-border-width-alt: .5pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"66\">\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\"><img loading=\"lazy\" decoding=\"async\" class=\"lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/LeftAnti.png\" alt=\"\" width=\"73\" height=\"49\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"lazyload\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/LeftAnti.png\" alt=\"\" width=\"73\" height=\"49\"><\/noscript><br><!--[endif]--><\/span><\/p>\n<\/td>\n<td style=\"width: 103.5pt; border-top: none; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; background: #D9E2F3; mso-background-themecolor: accent1; mso-background-themetint: 51; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"138\">\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">Left Anti<\/span><\/p>\n<\/td>\n<td style=\"width: 261.0pt; border-top: none; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; background: #D9E2F3; mso-background-themecolor: accent1; mso-background-themetint: 51; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"348\">\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">Filter(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; AddColumns(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table1,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8220;Value.2&#8221;,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LookUp(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Title =<br>Table1[@Title],<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2[@Value]<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; ),<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; IsBlank(&#8216;Value.2&#8217;)<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">)<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 49.25pt; border-top: none; border-left: solid white 1.0pt; mso-border-left-themecolor: background1; border-bottom: solid windowtext 1.0pt; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: windowtext; mso-border-left-alt: white; mso-border-bottom-alt: windowtext; mso-border-right-alt: white; mso-border-style-alt: solid; mso-border-width-alt: .5pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"66\">\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\"><img loading=\"lazy\" decoding=\"async\" class=\"lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Inner.png\" alt=\"\" width=\"73\" height=\"48\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"lazyload\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Inner.png\" alt=\"\" width=\"73\" height=\"48\"><\/noscript><br><!--[endif]--><\/span><\/p>\n<\/td>\n<td style=\"width: 103.5pt; border-top: none; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; background: #B4C6E7; mso-background-themecolor: accent1; mso-background-themetint: 102; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"138\">\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">Inner<\/span><\/p>\n<\/td>\n<td style=\"width: 261.0pt; border-top: none; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; background: #B4C6E7; mso-background-themecolor: accent1; mso-background-themetint: 102; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"348\">\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">Filter(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; AddColumns(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table1,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8220;Value.2&#8221;,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LookUp(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Title =<br>Table1[@Title],<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2[@Value]<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; ),<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; Not(IsBlank(&#8216;Value.2&#8217;))<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal; mso-yfti-cnfc: 64;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">)<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 49.25pt; border: solid white 1.0pt; mso-border-themecolor: background1; border-top: none; mso-border-top-alt: solid windowtext .5pt; mso-border-alt: solid white .5pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"66\">\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10327 lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Outer.png\" alt=\"\" width=\"75\" height=\"49\"><noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10327 lazyload\" src=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/Outer.png\" alt=\"\" width=\"75\" height=\"49\"><\/noscript><br><!--[endif]--><\/span><\/p>\n<\/td>\n<td style=\"width: 103.5pt; border-top: none; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; background: #D9E2F3; mso-background-themecolor: accent1; mso-background-themetint: 51; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"138\">\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\">&nbsp;Full Outer<\/span><\/p>\n<\/td>\n<td style=\"width: 261.0pt; border-top: none; border-left: none; border-bottom: solid white 1.0pt; mso-border-bottom-themecolor: background1; border-right: solid white 1.0pt; mso-border-right-themecolor: background1; mso-border-top-alt: solid white .5pt; mso-border-top-themecolor: background1; mso-border-left-alt: solid white .5pt; mso-border-left-themecolor: background1; mso-border-alt: solid white .5pt; mso-border-themecolor: background1; background: #D9E2F3; mso-background-themecolor: accent1; mso-background-themetint: 51; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\" width=\"348\">\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">Ungroup(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; Table(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MyTables: Filter(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AddColumns(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table1,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&#8220;Value.1&#8221;,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LookUp(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Title =<br>Table1[@Title],<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2[@Value]<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>IsBlank(&#8216;Value.1&#8217;)<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; },<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MyTables:<br>AddColumns(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table2,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&#8220;Value.1&#8221;,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LookUp(<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table1,<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Title =<br>Table2[@Title],<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>Table1[@Value]<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; ),<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">&nbsp;&nbsp;&nbsp; &#8220;MyTables&#8221;<\/span><\/p>\n<p style=\"margin-bottom: 0in; line-height: normal;\"><span lang=\"EN-US\" style=\"color: black; mso-color-alt: windowtext; mso-ansi-language: EN-US;\">)<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-135999e elementor-widget elementor-widget-spacer\" data-id=\"135999e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Tabellen samenvoegen in Power BI kan eenvoudig worden gedaan door de functies voor dat doel in de M- en\/of DAX-taal te gebruiken. Zie de blogpost die ik over dat onderwerp hier heb geschreven. Power Apps biedt deze functies niet, dus moeten we tabellen samenvoegen door gebruik te maken van Power Fx, de taal die gebruikt [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":10340,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[],"class_list":["post-10321","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-apps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tabellen samenvoegen in Power Apps - Minova<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/minova.nl\/en\/merge-tables-in-power-apps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tabellen samenvoegen in Power Apps - Minova\" \/>\n<meta property=\"og:description\" content=\"Tabellen samenvoegen in Power BI kan eenvoudig worden gedaan door de functies voor dat doel in de M- en\/of DAX-taal te gebruiken. Zie de blogpost die ik over dat onderwerp hier heb geschreven. Power Apps biedt deze functies niet, dus moeten we tabellen samenvoegen door gebruik te maken van Power Fx, de taal die gebruikt [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minova.nl\/en\/merge-tables-in-power-apps\/\" \/>\n<meta property=\"og:site_name\" content=\"Minova\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-05T12:50:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-05T11:42:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/thumbnail-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"528\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Marnix Jansen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marnix Jansen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/\"},\"author\":{\"name\":\"Marnix Jansen\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"headline\":\"Tabellen samenvoegen in Power Apps\",\"datePublished\":\"2021-07-05T12:50:36+00:00\",\"dateModified\":\"2023-05-05T11:42:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/\"},\"wordCount\":737,\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/thumbnail-1.jpg\",\"articleSection\":[\"Power Apps\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/\",\"url\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/\",\"name\":\"Tabellen samenvoegen in Power Apps - Minova\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/thumbnail-1.jpg\",\"datePublished\":\"2021-07-05T12:50:36+00:00\",\"dateModified\":\"2023-05-05T11:42:06+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/#primaryimage\",\"url\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/thumbnail-1.jpg\",\"contentUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/thumbnail-1.jpg\",\"width\":1280,\"height\":528},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/minova.nl\\\/tabellen-samenvoegen-in-power-apps\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/minova.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tabellen samenvoegen in Power Apps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\",\"url\":\"https:\\\/\\\/minova.nl\\\/\",\"name\":\"Minova\",\"description\":\"Van data naar inzicht\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/minova.nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\",\"name\":\"Marnix Jansen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"caption\":\"Marnix Jansen\"},\"sameAs\":[\"https:\\\/\\\/minova.nl\"],\"url\":\"https:\\\/\\\/minova.nl\\\/en\\\/author\\\/marnix\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Merge tables in Power Apps - Minova","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/minova.nl\/en\/merge-tables-in-power-apps\/","og_locale":"en_US","og_type":"article","og_title":"Tabellen samenvoegen in Power Apps - Minova","og_description":"Tabellen samenvoegen in Power BI kan eenvoudig worden gedaan door de functies voor dat doel in de M- en\/of DAX-taal te gebruiken. Zie de blogpost die ik over dat onderwerp hier heb geschreven. Power Apps biedt deze functies niet, dus moeten we tabellen samenvoegen door gebruik te maken van Power Fx, de taal die gebruikt [&hellip;]","og_url":"https:\/\/minova.nl\/en\/merge-tables-in-power-apps\/","og_site_name":"Minova","article_published_time":"2021-07-05T12:50:36+00:00","article_modified_time":"2023-05-05T11:42:06+00:00","og_image":[{"width":1280,"height":528,"url":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/thumbnail-1.jpg","type":"image\/jpeg"}],"author":"Marnix Jansen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marnix Jansen","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/#article","isPartOf":{"@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/"},"author":{"name":"Marnix Jansen","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"headline":"Tabellen samenvoegen in Power Apps","datePublished":"2021-07-05T12:50:36+00:00","dateModified":"2023-05-05T11:42:06+00:00","mainEntityOfPage":{"@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/"},"wordCount":737,"image":{"@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/thumbnail-1.jpg","articleSection":["Power Apps"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/","url":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/","name":"Merge tables in Power Apps - Minova","isPartOf":{"@id":"https:\/\/minova.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/#primaryimage"},"image":{"@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/thumbnail-1.jpg","datePublished":"2021-07-05T12:50:36+00:00","dateModified":"2023-05-05T11:42:06+00:00","author":{"@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"breadcrumb":{"@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/#primaryimage","url":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/thumbnail-1.jpg","contentUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2021\/07\/thumbnail-1.jpg","width":1280,"height":528},{"@type":"BreadcrumbList","@id":"https:\/\/minova.nl\/tabellen-samenvoegen-in-power-apps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minova.nl\/"},{"@type":"ListItem","position":2,"name":"Tabellen samenvoegen in Power Apps"}]},{"@type":"WebSite","@id":"https:\/\/minova.nl\/#website","url":"https:\/\/minova.nl\/","name":"Minova","description":"From data to insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minova.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e","name":"Marnix Jansen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","caption":"Marnix Jansen"},"sameAs":["https:\/\/minova.nl"],"url":"https:\/\/minova.nl\/en\/author\/marnix\/"}]}},"_links":{"self":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/10321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/comments?post=10321"}],"version-history":[{"count":15,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/10321\/revisions"}],"predecessor-version":[{"id":10993,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/10321\/revisions\/10993"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media\/10340"}],"wp:attachment":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media?parent=10321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/categories?post=10321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/tags?post=10321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}