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

Community site session details

Session Id : HeKNe97Bv+CfaKo4ER7O0Z
Power Pages - General Discussions
Unanswered

Master table

Like (0) ShareShare
ReportReport
Posted on 20 Nov 2023 18:59:06 by 117

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:

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 2

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 2

#3
surya narayanan Profile Picture

surya narayanan 35