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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Problem appending two ...
Power Apps
Unanswered

Problem appending two dataverse tables

(0) ShareShare
ReportReport
Posted on by 35

I am trying to append two dataverse tables which I created as a test (test table1 and test table2) and added one column (person) to both tables with some information (everything else equal). I would like the test table1 information to be on top and then test table2 information on bottom and then create a third table where this information would be listed. I use the dataflow and power query editor, but when I try to choose "Combine" and "Append queries" it takes forever to load and results in the following error:

 

---------- Message ----------
We're sorry, an error occurred during evaluation.

---------- Session ID ----------
f8816cd7-19f7-40c9-9b5f-be7d4f933959

---------- Request ID ----------
65c5ee9f-5481-49f2-a094-0037bdb875c3

---------- Mashup script ----------
section Section1;
shared cr7a7_testtable1 = let
Source = CommonDataService.Database("org9c765cbd.crm4.dynamics.com"),
#"Navigation 1" = Source{[Schema = "dbo", Item = "cr7a7_testtable1"]}[Data],
#"Appended query" = Table.Combine({#"Navigation 1", cr7a7_testtable2})
in
#"Appended query";
shared cr7a7_testtable2 = let
Source = CommonDataService.Database("org9c765cbd.crm4.dynamics.com"),
#"Navigation 1" = Source{[Schema = "dbo", Item = "cr7a7_testtable2"]}[Data]
in
#"Navigation 1";

 

Screenshot1.PNG

Categories:
I have the same question (0)

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard