Merging two Dataverse Tables in a View

(0) Share

Report

Posted on by Amad233

I have the following view

The above is from a single table.,

I have 2 tables from Dataverse containing similar informations like:
Reference, Date Submitted, Company, Status

There are no foreign keys or lookups relating the table.

Taking as example as using UNION in sql, how can I merge the two tables into a single view??
I am currently using either API or fetchXML to display data on my PowerPage website.

If anyone of you have met the same situation or know how to resolve the problem
Any help is appreciated

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

fm_skeller 277 Moderator on at

Like (1)

Report

As far as I know you cannot do a union-like statement with views and/or liquid. You could use the API or FetchXML to query both tables and use liquid/javascript to combine both into 1 table.
You could also create a third table, where you add new rows whenever either table is modified - and display that table.

Was this reply helpful? Yes No
domliu37 314 Super User 2024 Season 1 on at

Like (2)

Report

Hi @Amad233 ,

I dont believe there's any ootb way to achieve that. As you already use fetchXML to retrieve data, maybe just use 2 fetchXML to retrieve the data from both table, then use code to display the data in a single view, make sure have the same columns etc.

----------------------
If you enjoy this post, click the thumbs-up button. If it helped you, mark it as a solution so others can find it easily.

Cheers,
Dom

Was this reply helpful? Yes No
Verified answer

Lucas001 2,429 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Amad233,

I guess both of the others already point out a good example on how the problem could be solved.
There are some more things I would like to ask:
If the data is kind of similar, is it really necessary to store them in two different tables?
Is there a column which could connect both tables? If so you could use a reference like a formula column and combine everything in one big table or further extend one of the two existing.
The best approach here would probably be to use fetchXML as already pointed out and get 2 querys running. Join the two JSONs, or arrays, depending on how you set it up in one variable. After that use a for-loop or a for each and display the view on your page while populating the DOM as needed.

--------------------------------------------------------------------------------------

Hope that helps.

If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.

Was this reply helpful? Yes No
Amad233 27 on at

Like (0)

Report

It's kinda sad though.
Dataverse huh 😂
It's supposed to be super powerful
Cannot even do a UNION
Guess I'll have to create another table then, easiest and most manageable solution (In my opinion)
Thanks Guys
This is the first time people are replying to my post. Really appreciate it 👍
@Lucas001 @domliu @fm_skeller

Was this reply helpful? Yes No
Lucas001 2,429 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Amad233,

hope you will be able to implement your solution.
Could you accept one or more posts as a solution? It helps to us when looking for open posts to solve.

Actually there are a lot of active members in the power pages community. Do you have other open posts?

In case you have any more issues or questions, please feel free to ask or open a new post.

Was this reply helpful? Yes No