You’re offline. This is a read only version of the page.
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
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.
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 👍
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:
--------------------------------------------------------------------------------------
Hope that helps.
If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.
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
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.
Share
Report
27
All responses (
Answers (
