Using FetchXML in a Power Apps Portal Web Page Template

In this post, we will look at how to use FetchXML in a Power Apps Portal Web Page and Template.

First, let’s go to the Portal Administration app and create a new Web Page Template:

Paste in the FetchXML like below. You can see we are creating a new web template, and running a FetchXML query, then iterating through the results and returning them in a JSON format:

Scroll down to the bottom of the page and set the MIME type to application/json:

Next, create a new Page Template:

Select the Web Template, uncheck Website Header and Footer like below:

Next, create a Web Page and reference the template:

Now, if we were to go to the accounts page, we see there are no results:

Be sure to confirm that the user has web roles with table permissions to retrieve the data you need.

Now, let’s say we need to pass parameters to the FetchXML. Let’s pass the company name to our FetchXML query through the request.params:

Now if we run the page without any parameters, we get no results:

If we run the page with the companyname parameter, our FetchXML runs as expected with the parameter:

Note the user would need to have permission to see the record.

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.com | LinkedIn | Twitter | YouTube

Facebook

Twitter

Linkedin