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 tableline 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 %}
------------------------------------------------
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
Post a Comment