วีดีโอ

Possible, but it does require you build it yourself with custom JavaScript and Liquid/Web API.

We've seen similar problems - if you enable the settings after performing a scan, subsequent scans still show it as a problem. For now, we believe this is just a bug with the scan, and would expect that to be fixed at some point before the tool becomes generally available.

Datasets are now supported on Power Pages.

What do you dislike so much about Liquid?

You can certainly make Google Maps work, but it involves writing your own custom code. Nothing supported out-of-the-box with just configuration for Google Maps.

The metadata/configuration tables (most of the adx_ and mspp_ - full list available here: learn.microsoft.com/en-us/power-pages/admin/clear-server-side-cache#metadataconfiguration-tables) have slightly different caching rules. So I think what you're seeing is less about the fact that they are virtual tables, and more because web role is a metadata/configuration table.

Yes, I'd say the video is still accurate. There still isn't support for MDA dashboards, so your options are Power BI, using Liquid, or custom JS to build your own.

There is another table called "Settings" (instead of Site Settings), which is in Dataverse. However, there are also many other settings that are not stored in Dataverse and that we don't have access to outside of the typical interfaces. Most of what you see in the Power Platform Admin Center falls into that category - for example, whether CDN and WAF is enabled, SSL settings, etc.

Yes! We offer our Power Pages Training course: www.engineeredcode.com/power-pages-training It includes an online, self-paced course, along with office hours and priority community support. We can also offer customized training via our consulting packages.

@@EngineeredCode will this training covers all the concepts of powerpages?

We can't promise "all concepts". The goal is to be comprehensive, but of course there is always more topics that could be covered.

Sorry! The environment used for this video is gone, so I don't have the code handy.

It should be doable via some custom JS. Maybe I can tackle that in an upcoming blog post.

@@EngineeredCode That'd be amazing!

Agreed! Along with Twig.

We target them using CSS that we included in our custom page. You can use your browser developer tools to inspect to find out what classes and ID exist on the elements you want to change.

You can register here: www.engineeredcode.com/portals-community-call Looking forward to having you join the calls!

"Scan files for malware" is mentioned in the 2024 Wave 2 Release Plans: learn.microsoft.com/en-us/power-platform/release-plan/2024wave2/power-pages/file-upload-enhancements-power-pages-sites

I think if you have the CDN enabled, then you can't use the old restrict website access by IP address that comes with Power Pages. However, I believe you can use the WAF to restrict by IP address in that case.

Not for the Microsoft-hosted version. They released the source code so that you could host it yourself, but there still is no way to change the source code yourself for Power Pages (which are always hosted by MS).

Are you referring to the desktop version or web version? For the desktop version, to get the latest changes, you would just download again. For the web version, simply refresh the page.

@@EngineeredCode yes I got we have download again with Overwrite

For Power Pages, "relevant" means related to. So you need to relate the contacts to the rows you want them to see. Then you can setup permissions so that they only see rows they are related to.

I don't think FetchXML is any different - it should work. Is there a chance you don't have table permissions setup for your other table? That would be required to get details from the related table.

My first thought is using permissions. If you create table permissions from contact to location to the table shown in the list, the list will only show the rows the user has access to (i.e. is linked to via the location relationship).

@@EngineeredCode So would that mean making permissions for each location then assigning that location as a web role to the user? Thanks for answering!! Wasn't expecting it. I really enjoy your content.

Table permissions aren't setup on a specific row (in this case, specific location). Instead, permissions are based on whether the contact who is logged is related to a row. So right now you might have a global permission on the Location table and the Items table. This means your contacts can see all locations and items. Instead, if you create a permission for Locations with an access type of contact (to do this, you'll select the relationship between contacts and locations), then only locations related to the contact will be available. Then you can create a child permission from locations to items. This will make it so that only items related to locations related to the logged in contact will be available.

Check out the regular expression validation in form metadata: th-cam.com/video/nUFvsQ-haWU/w-d-xo.html

Hmm. I can't seem to get it to work either. I'm wondering if this is because Multi-step forms can't be displayed in a modal?

I definitely agree that it seems to accept addresses that don't seem real. I know the code does call the Bing API to perform the validation - it basically searches for that address string, and if anything is returned, it is considered valid. My guess is that the Bing API is very generous on what it considers a match.

Sorry I'm not quite following. Does the column that it mentions is missing exist or not? Perhaps there is a reference somewhere to a column that used to exists, but no longer does, so those references need to be removed.

Yes, for the content access levels, you need one of the D365 templates such as customer/employee self-service, community or partner.

Do you need a different version of jQuery? Or could you just include your JS further down the page so that jQuery is included before your code?

@@EngineeredCode I am running a script that generates the header and footer section on the Portal following the CDTS implementation to render GoC's WET templates. To render these the script has to be in the head section, so I placed the code in the Head/Bottom snippet. The code is pure vanilla JS however I am running some jQuery in the Head/Bottom to make some changes to the header. Could I place that jQuery in web template?

Yeah that code could possible go in the header or footer web templates.

Hmm. When using the current contact filtering, it should be using the ID of the contact, not any of the name fields.

You should be able to use FetchXML to run the query. However, the header, footer and body of the page are processed separately so I'm not sure how you would stop the page from rendering (aside of perhaps writing out some JavaScript) that forces a redirect, which isn't really secure). I would probably use the FetchXML in the body of the page instead, to hide the content that should be secured, instead of doing it in the header.

@@EngineeredCode Thanks for the reply. I decided to wrap a FetchXML template (that takes a guid of an account and current user.id as filter options) around the content of the page (which is template itself) so that if the results/size is greater than or equal to 1 is renders the page, else show a warning alert and redirect user back to a dashaboard. This will be in the body of the page as you suggested. I will test this out. Thanks!

nothing stops you from acquiring dataverse access token on portal side and performing a call to an end point you need. Unless your portal has no authentication on. A handy lib is MSAL which will help you to exchange a user token id and get dataverse access token.

Companion App is definitely one way to do it. You could also use the Power Automate integration via the Web API.

You need to go into the Power Pages Management (if you're using the Enhanced Data Model) or Portals Management (if you're using the Standard Data Model) model-driven app. Then go to either Basic Forms or Multistep Forms, and find the form you are wanting to setup the metadata for (if you're doing it for a Multistep Form, you need to open the specific step). Form Metadata is a related table to Basic Forms and Multistep Form Steps, so you'll find them in the Related dropdown. You can then create new Metadata records from there.

By autocomplete, do you mean that when they click on the map, the address is filled in?

​@@EngineeredCodewhen the user starts typing it should suggest the address

I'm not sure if there is any built-in functionality for that.

I mean address autocomplete

Unfortunately I don't think the filtering applies to the Calendar view.

Yes and no. You can't really control whether a user can create an Azure AD B2C account, because as you've pointed out, we use the sign in and sign up flow. But you can stop them from accessing the portal after they've created that B2C account. If you turn off open registration, then the only way in is via an invitation code. So if a user clicks the sign in link without an invitation code, sets up a B2C account, then logs in, they'll get an error.

Depends on what you mean by "possibly use". In JavaScript you can also use headers that may not be in that list. Is there a specific header that you're wondering about?

@@EngineeredCode Actually, yes. The "Clear-Site-Data" response header can, for example, request that the browser clear site cache, cookies, etc. This would not be something you want on every page of your site, but if you had a custom LOGOUT page, this could be very useful in certain situations.

Unfortunately I'm not aware of any way of controlling at header.

I think this works for activities as well. At least it did when this video came out :)

​@@EngineeredCode Yeah it might've changed because there is no row layout section in the tab properties on my end. The page size for the portal comments seems fixed at 15 by default so it's not too bad. Thank you!

Unfortunately I don't believe so.

Only if you somehow allow end users to create their own queries. Liquid is a server-side language, so end-users can't execute their own arbitrary Liquid code. So you would want to avoid inserting any user-provided text into your FetchXML so that you don't have injection problems. And I'm not sure if the stringmap table is even possible to access via the Power Pages Web API, but if so, you'd want to ensure that it isn't enabled.

@@EngineeredCode perfect thanks!

I'm not sure. Can you give me any additional details as to what you've setup or what it is showing? Does it appear to show the right location, but just the pin itself is missing?