Announcements
In Power Apps we would like to condense entities, so would like to move columns (and there are many,) from one table to another. Is this possible? For example: Move Field A & B from Table 1 to Table 2.
Table 1
Field A
Field B
Table 2
Field C
Field D
Any advice would be much appreciated
Many thanks
You can Add Columns from Table 1 to Table 2 using the AddCoulmns function, would this work?
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/ YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg Twitter: https://twitter.com/phipps0218
How is the data configured in the back end? Do you use Premium SQL table connector, Dataverse or something else? It might be better option to move the data from its source to what you need the configuration to be, but i'd need some more information?
@Xch21 Thanks
Hi JasonLane
Thank you for you quick reply. We use Dataverse tables
Regards
Hi
Thanks for your help. We can add each row again in Table 2 by Adding a column function but as we have over 70 columns we were hoping this could be done in a less time consuming way than creating each column again individually. Is there way to do this do you know? Thank you
@Xch21 There might be a way using PowerAutomate - Its really down to the structure of the tables but perhaps this article can set you on the way - https://learn.microsoft.com/en-us/power-automate/dataverse/create . Sorry i cannot be much more help - I get what you are trying to do but its pretty niche
Thank you for trying anway
Best regards
If this is a solution please can you accept.
Thanks
Jason
@JasonLane This is not a solution.@Xch21I am trying to understand the issue. Why have you got 2 tables? Are you trying to combine these two tables so you only need to load one into Power Apps?
My question is why have you got the two tables in the first place?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
