Fetch 2 tables records using FetchXML in Power Automate| Show 2 tables records in 1 in Portal Pages

This video will cover :

👉How to create FetchXML query in Power Portal and link two tables records in one

👉How to get two tables records in ONE using Power Automate FetchXML Query

👉Power Portal get columns from multiple tables and show it in Single table with custom script

You can get the complete code in my comment section:

Learn PowerApps, Power Automate and Power Portal Page in one-to-one session
Get assistance on your project .
Contact me on WhatsApp [phone]

Charges are applicable as per requirement.

[powerexpertise]

Code
<div class="container" style="margin-top:50px">
{% fetchxml crbe1_employeesList %}

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="crbe1_employees">
<attribute name="crbe1_employeesid" />
<attribute name="crbe1_employeeid" />
<attribute name="createdon" />
<order attribute="crbe1_employeeid" descending="false" />
<filter type="and">
<condition attribute="crbe1_employeeid" operator="eq" value="1234" />
</filter>
<link-entity to="crbe1_employeename" visible="false" link-type="outer" alias="a_merged">
<attribute name="crbe1_street" />
<attribute name="crbe1_pincode" />
<attribute name="crbe1_phonenumber" />
<attribute name="crbe1_name" />
<attribute />
<attribute name="crbe1_country" />
<attribute name="crbe1_city" />
</link-entity>
</entity>
</fetch>
{% endfetchxml %}

<div class="table-responsive">
<table id="tblData" class="table" style="border:1px solid" data-page-length='25'>
<thead class="thead-dark">
<tr class="table-heading">
<th>Employeee ID</th>
<th>Employeee Name</th>
<th>Employee City</th>
</tr>
</thead>

{% for result in %}
<tr>
<td>{{


</tr>
{% endfor %}

</table>
</div>
</div>

[MedariKeshava]

Hi, I have one doubt regarding fetchxml in Power Pages, can you answer my doubt please