Learn Power Apps portal Liquid better understanding with hands on

 PowerApps Portal, Learn few example of arrays.

Example 1:

{% for i in (1..5) %}

{{ i }}

{% endfor %}


Example 2:

{% assign myarray = "Koti,Bala,Sai,Teja" | split:',' %}

{{myarray}}

<br />

For loop output:<br />

{% for obj in myarray %}

{{obj}}

{%endfor%}

Example 3:

Filter with in the array data by using if condition

{% for i in (1..5) %}
{% if i == 4 %}
{{ i }}
{%endif%}
{% endfor %}

Another best example of filter using if condition

{% for i in (1..5) %}
{% if i == 4 %}
{% continue %}
{% else %}
{{ i }}
{% endif %}
{% endfor %}

Example 4:

Fetch entity data (dataverse data)

The below example: transactioncurrency is the table name(internal table name).
"Active Currencies" is the view name.

{% entityview logical_name:'transactioncurrency', name:'Active Currencies' %}
<p>We support {{ entityview.total_records }} currencies.</p>
<ul>
{% for cur in entityview.records -%}
<li>{{ cur.currencyname }}</li>
{% endfor %}
</ul>
{% endentityview %}
Output
We support 4 currencies. Australian dollar Canadian dollar Euro US dollar

other example:
custom entity name "cr1bc_mobileproductdetails" and view name is "Active Mobile Product Details".

{% entityview logical_name:'cr1bc_mobileproductdetails', name:'Active Mobile Product Details' %}
<p>We support {{ entityview.total_records }} currencies.</p>
<ul>
{% for cur in entityview.records -%}
<li>{{ cur.cr1bc_productname }}</li>
{% endfor %}
</ul>
{% endentityview %}
Output:

We support 2 currencies.

  • sample 1
  • sample 2

------------------------------------------------
Other example.
line 1: Define the table name:
line 3: variable batches assigning the records/items in the table
line 2: shows the total count of records


{% entityview logical_name:'cr1bc_mobileproductdetails', name:'Active Mobile Product Details' %}
<p>We support {{ entityview.total_records }} currencies.</p>
{% assign batches = entityview.records | batch: 2 %}
{% for batch in batches %}
<ul>
{% for item in batch %}
<li>{{ item.cr1bc_productname }}</li>
{% endfor %}
</ul>
{% endfor %}
{% endentityview %}

Table Permission

{{user.id}}
{% if user %}
<p>
{% assign account = tables.account[user.parentcustomerid.id] %}
{% if account and account.permissions.can_read %}
Company: {{account.name}}
{% else %}
Unknown company
{% endif%}
</p>
{% endif %}
---------------------------------------------

showing the list of data in dataverse "Account" and "Active Accounts" view

<h2>List of accounts</h2>
{% entityview logical_name:'account', name:'Active Accounts' %}
<p>We have {{ entityview.total_records }} accounts.</p>
<ul>
{% for account in entityview.records -%}
<li>{{ account.name }}
{% if account.telephone1 %}
(<a href="tel:{{ account.telephone1 }}">{{ account.telephone1 }}</a>)
{% endif %}
</li>
{% endfor %}
</ul>
{% endentityview %}
-------------------------------------------

Comments

Hello{% comment %}, {{ user.fullname }}{% endcomment %}. My name is Charles.
------------------------------------------

Comments

Popular posts from this blog

Powerapps overcome 2000 item limit from any datasource

PowerApps multiselect cascading dropdown and save an item to SharePoint List

Multi select cascading dropdown in Power Apps