Power Platform Community Forum Thread Details

Master table

Is it possible to create a master table if we have this setup?

We have 3 Sharepoint lists and 3 external SQL tables which we made into virtual tables.

To simplify, let's use just one Sharepoint table.

Each logged in Powerpage user has a column with with an identifier.

The Sharepoint list has a column where we can filter only the records where user.identifier = sharepoint_table.identifier

Now we get a list from that sharepoint table. Each record has another identifier.

With that identifier and we need to search in the virtual SQL tables. It gets pretty complicated. We search with the identifier we got into a SQL table, then we get a column from that SQL table and look it up in another SQL table, and finally there we get the needed value.

Now we query Liquid fetchxml and combining everything with JS, but the page loads slow because of the many records, for one table we get 8k records because we can't filter it properly using fetchxml .

We thought if possible to make a master table using the Formula datatype maybe.

Any idea about how we can make this, if even possible?

Categories:

General

Quick Links

Leaderboard > Power Pages