{"id":25609,"date":"2020-11-18T11:05:02","date_gmt":"2020-11-18T11:05:02","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=25609"},"modified":"2023-09-08T13:01:15","modified_gmt":"2023-09-08T07:31:15","slug":"use-of-json-type-web-templates-in-powerapps-portals","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/11\/use-of-json-type-web-templates-in-powerapps-portals\/","title":{"rendered":"Use of JSON Type Web Templates in PowerApps Portals"},"content":{"rendered":"

Introduction<\/strong><\/h1>\n

Microsoft PowerApps Portals provide us the configuration surface which allows users to add forms to collect data in the portal without custom development. Web Template is a Power Apps entity (adx_webtemplate), included with Power Apps portals, that is used to store template source content. A web template will generally contain Liquid for dynamic content rendering and is the central entity used to integrate Liquid templates with the rest of the Power Apps portals system.<\/p>\n

While the most common use cases for Web Templates will be to render HTML, rendering the entire response (by deselecting\u00a0Use Website Header and Footer<\/strong>) gives you the option of rendering any text-based format you choose. This is where the\u00a0MIME Type<\/strong> attribute of Web Template becomes relevant. When a Page Template that does not use the website header and footer is rendered, the HTTP response Content-Type header will be set to the MIME type of the associated Web Template. (text\/HTML will be used if no MIME Type is provided.).<\/p>\n

In this blog, we will see how we can create a Web Template with application\/jsonMIME Type <\/strong>to get data using FetchXml and how we can retrieve that JSON data through Ajax request in the script.<\/p>\n

Here, we will take the example of filtering Account<\/strong> lookup (which is rendered as a dropdown) based on different Relationship Types <\/strong>field value. So, to retrieve Account<\/strong> entity data we will configure JSON type Web Template and to get the data based on different Relationship Types <\/strong>field value we will require to pass specific Relationship Type to Web Template through query string parameter<\/strong>.<\/p>\n

Below are the configurations steps required to retrieve data using JSON type Web Templates,<\/p>\n

1.<\/strong>\u00a0Configure Web Template<\/strong> with MIME Type = application\/json<\/strong>. Then add FetchXml and code to generate JSON of retrieved data in Source<\/strong> field of the Web Template as per requirement. For reference find below screen clip,<\/p>\n

Get Account JSON Web Template<\/strong><\/u>:<\/h2>\n

\"Use<\/a><\/p>\n

Below is the sample code to retrieve Account data using FetchXml and generate JSON of retrieved data which we have added in Source<\/strong> field of GetAccountJSON<\/strong> Web Template:<\/p>\n

{% fetchxml accounts %}<\/p>\n

<fetchversion=”1.0″output-format=”xml-platform”mapping=”logical”distinct=”false”><\/p>\n

<entityname=”account”><\/p>\n

<attributename=”name”\/><\/p>\n

<attributename=”primarycontactid”\/><\/p>\n

<attributename=”telephone1″\/><\/p>\n

<attributename=”accountid”\/><\/p>\n

<orderattribute=”name”descending=”false”\/><\/p>\n

<filtertype=”and”><\/p>\n

<conditionattribute=”customertypecode”operator=”eq”value=”{{request.params[‘relationshiptype’]}}”\/><\/p>\n

<\/filter><\/p>\n

<\/entity><\/p>\n

<\/fetch><\/p>\n

{% endfetchxml %}<\/p>\n

{% if accounts.results.entities.size > 0 %}<\/p>\n

{<\/p>\n

“results”:<\/p>\n[<\/p>\n

{% for account in accounts.results.entities %}<\/p>\n

{<\/p>\n

“name”:\u00a0 “{{<\/strong>account.name}}<\/strong>“,<\/p>\n

“id”: “{{<\/strong>account.accountid}}<\/strong>”<\/p>\n

}<\/p>\n

{% unless forloop.last %},{% endunless %}<\/p>\n

{% endfor %}<\/p>\n

]\n

}<\/p>\n

{% else %}<\/p>\n

No data found.<\/p>\n

{% endif %}<\/p>\n

In above sample code, {{request.params[‘relationshiptype’]}}<\/strong>is added to get relationship type from query string parameter. And in the same way, we can pass multiple parameters and use them in FetchXml.<\/p>\n

2.<\/strong> Create Page Template <\/strong>record to get account JSON and then set GetAccountJSON <\/strong>web template in Web Template<\/strong> field of Page Template. Also, uncheck the Use Website Header and Footer<\/strong> checkbox of Page Template as shown below,<\/p>\n

Get Account JSON Page Template<\/strong><\/u>:<\/h2>\n

\"Use<\/a><\/p>\n

3.<\/strong> After that create Web Page <\/strong>record and set Get Account JSON<\/strong> Page Template in Web Page as shown below. Also, the Partial URL<\/strong> will be useful to retrieve JSON.<\/p>\n

Get Account JSON Web Page<\/strong><\/u>:<\/h2>\n

\"Use<\/a><\/p>\n

4.<\/strong> Create Entity Permission<\/strong> for the respective entity and add appropriate Web Role<\/strong> in that entity permission to be able to read the respective entity records. In this example, we will create entity permission for Account<\/strong> For reference find below screenshot,<\/p>\n

Account Entity Permission<\/u>:<\/h2>\n

\"Use<\/a><\/p>\n

After all the above configurations, we will be able to retrieve the data from JSON <\/strong>type Web Template<\/strong> using Ajax request in script code. So, we will add the below code in the Custom JavaScript section of Entity Form<\/strong> to retrieve Account<\/strong> data from JSON type Web Template and bind retrieved data in Account<\/strong> lookup,<\/p>\n

Entity Form<\/u>:<\/h2>\n

\"Use<\/a><\/p>\n

Code<\/u>:<\/p>\n

$(function () {<\/p>\n

\/\/Get account data<\/p>\n

getAccountData();<\/p>\n

\/\/Execute on relationship type change<\/p>\n

$(‘#new_relationshiptype’).change(function () {<\/p>\n

try {<\/p>\n

\/\/Get account data<\/p>\n

getAccountData();<\/p>\n

} catch (e) {<\/p>\n

console.log(“onChangeOfRelationshipType :: ” + e.message);<\/p>\n

}<\/p>\n

});<\/p>\n

\/\/Function to get account data<\/p>\n

function getAccountData() {<\/p>\n

var webTemplateURL = “”;<\/p>\n

var relationshipType = “”;<\/p>\n

var accountName = “”;<\/p>\n

var accountId = “”;<\/p>\n

var accountCollection = null;<\/p>\n

try {<\/p>\n

\/\/get selected relationship type<\/p>\n

relationshipType = $(“#new_relationshiptype”).val();<\/p>\n

\/\/Clear account field<\/p>\n

$(“#parentcustomerid”).empty();<\/p>\n

\/\/Add empty option in the account dropdown<\/p>\n

$(“#parentcustomerid”).append(‘<option value=”” label=” “><\/option>’);<\/p>\n

\/\/Validate relationship type<\/p>\n

if (!isValid(relationshipType)) { return; }<\/p>\n

\/\/Web tempalte url to retrieve account url<\/p>\n

webTemplateURL = “\/getaccountjson\/?relationshiptype=” + relationshipType + “”;<\/p>\n

\/\/Request to custom page to get account data in json format<\/p>\n

accountCollection = getResponse(webTemplateURL);<\/p>\n

\/\/Validate account result<\/p>\n

if (accountCollection.results.length > 0) {<\/p>\n

\/\/Check for each account from account collection<\/p>\n

accountCollection.results.forEach(function (account) {<\/p>\n

\/\/Check for account name and account id from account collection<\/p>\n

if (isValid(account.name) && isValid(account.id)) {<\/p>\n

\/\/Get account name<\/p>\n

accountName = account.name;<\/p>\n

\/\/Get account id<\/p>\n

accountId = account.id;<\/p>\n

\/\/Append options to account dropdown<\/p>\n

$(“#parentcustomerid”).append(‘<option value=’ + accountId + ‘>’ + accountName + ‘<\/option>’);<\/p>\n

}<\/p>\n

});<\/p>\n

}<\/p>\n

} catch (e) {<\/p>\n

console.log(“getAccountData :: ” + e.message);<\/p>\n

}<\/p>\n

}<\/p>\n

\/\/Function to execute ajax request<\/p>\n

function getResponse(webTemplateURL) {<\/p>\n

var response = null;<\/p>\n

try {<\/p>\n

$.ajax({<\/p>\n

type: “GET”,<\/p>\n

url: webTemplateURL,<\/p>\n

dataType: “json”,<\/p>\n

async: false<\/p>\n

}).done(function (json) {<\/p>\n

response = json;<\/p>\n

});<\/p>\n

} catch (e) {<\/p>\n

console.log(“getResponse :: ” + e.message);<\/p>\n

}<\/p>\n

return response;<\/p>\n

}<\/p>\n

\/\/Validate attributes<\/p>\n

function isValid(attributes) {<\/p>\n

try {<\/p>\n

if (attributes != null&& attributes != undefined && attributes != “”) {<\/p>\n

returntrue;<\/p>\n

}<\/p>\n

else {<\/p>\n

returnfalse;<\/p>\n

}<\/p>\n

} catch (e) {<\/p>\n

console.log(“isValid :: ” + e.message);<\/p>\n

}<\/p>\n

}<\/p>\n

});<\/p>\n

In above code, webTemplateURL = “\/getaccountjson\/?relationshiptype=” + relationshipType + “”;<\/strong>is the URL prepared to get account data and this URL getaccountjson<\/strong>is nothing but the Partial URL added on Get Account JSON Web Page. Also, relationshiptype=” + relationshipType + “<\/strong>is added to pass Relationship Type as a query string parameter.<\/p>\n

Note<\/u><\/em><\/strong>:<\/strong> Instead of Home <\/strong>parent page if you want to set any other parent page in Web Page of JSON page then you need to add Partial URL of Parent Page as well in Ajax request i.e. suppose in above example we select Profile<\/strong> page as a parent page instead of Homepage<\/strong> then the URL for Ajax request will be as below<\/em>,<\/p>\n

Get Account JSON Web Page<\/strong><\/u>:<\/h2>\n

\"Use<\/a><\/p>\n

Ajax request URL<\/u>:<\/p>\n

webTemplateURL = “\/profile<\/strong>\/getaccountjson\/?relationshiptype=” + relationshipType + “”;<\/p>\n

Now, on the portal side, we can see if Relationship Type <\/strong>is not selected then Account<\/strong>fieldnot listing any account to select,<\/p>\n

\"Use<\/a><\/p>\n

And, below is the screen clip with Relationship Type <\/strong>selected and filtered accounts listed in Account<\/strong> dropdown,<\/p>\n

\"Use<\/a><\/p>\n

Conclusion<\/strong><\/h1>\n

In this blog, we have seen how we can use JSON type Web Templates in Power Apps Portals.<\/p>\n

Free 70% of storage space in CRM with Attachment Management Apps!<\/div><\/div><\/h2>\n

Attach2Dynamics<\/a> – Store and manage documents\/attachments in cloud storage of your choice – SharePoint, Dropbox or Azure Blob Storage from within Dynamics 365 CRM.<\/strong><\/em>
\nSharePoint Security Sync<\/a><\/strong> \u2013 Robust and secure solution to integrate Dynamics 365 CRM and SharePoint Security Sync thereby ensuring secure access to confidential documents stored in SharePoint.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Microsoft PowerApps Portals provide us the configuration surface which allows users to add forms to collect data in the portal without custom development. Web Template is a Power Apps entity (adx_webtemplate), included with Power Apps portals, that is used to store template source content. A web template will generally contain Liquid for dynamic content\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,19,37,44,38,2053,2763],"tags":[545,592,672,1101,1170,1338,2027],"class_list":["post-25609","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-dynamics-crm","category-microsoft-portals","category-power-apps","category-microsoft-powerapps","category-power-apps-portals","category-power-pages","tag-dynamics-365-crm","tag-dynamics-crm","tag-dynamics-crm-powerapps","tag-microsoft-dynamics-365-powerapps","tag-microsoft-powerapps","tag-power-apps-dynamics-365-crm","tag-power-apps-portal"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/25609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=25609"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/25609\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=25609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=25609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=25609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}