Virtual Tables - ALM variables announcement & Power Pages

ALM variables, filtering on virtual tables and creating them straight from Power Pages?

As some of you may have noticed during my MPPC session, I’ve been honored to work together with 2 absolute rockstars within Microsoft, to fact check my Virtual Table information, and to get amazing new announcements out there!

Pranita Padalwar Senior Product Manager for Power Pages, very generously provided information I could share for Power Pages which is so amazing I cannot wait to show you here!

And then Nathan Helgren Principal Program Manager Dataverse, and allround Expert on anything Virtual Table related, also tremendously helped me with fact checking my content, making sure I captured everything I could, and provide me with his own brand new shiny screenshots and details.

/posts/virtualtablesmppc23announcements/nathan.jpg
Me and Nathan in the speaker room preparing some content

As you can imagine it was really hard to keep this quiet (but I managed, thankfully, my NDA trust is still intact, lol)

Then, at MPPC, during Nathan’s own session, he ran out of time to announce something first, leaving me with the exclusive to announce during my session, and now I get to share it here as well!!

So without further ado and introduction, here are the 2 announcements:

You can now add your own environment variables during the move in ALM for Virtual Tables!

/posts/virtualtablesmppc23announcements/ppenvalm0.png
New option to add environment variables

It will give you the option in the wizard to add the names in there.

/posts/virtualtablesmppc23announcements/ppenvalm.png
Specify your database and servername in the wizard when going through ALM

You can filter on virtual or regular on the add table interface, and the icon has also changed to differentiate between the types of tables, Virtual vs Dataverse

/posts/virtualtablesmppc23announcements/ppfilter.jpg
New filter option and icons

Currently you can add an existing virtual table to Power Pages, however….

You can now create a Virtual Table straight from Power Pages with SQL and Sharepoint (lists)!

You can do this through the newly added - connect to an external table data option.

/posts/virtualtablesmppc23announcements/ppaddexternal.jpg
Add a Virtual Table straight from Power Pages

These features will be in Private Preview in October!