web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Show data using Liquid...
Power Apps
Unanswered

Show data using Liquid in PowerAps Portal

(0) ShareShare
ReportReport
Posted on by 357

I want to fetch data from EmployeeForm Entity using Liquid.
My code:

{% fetchxml feed %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" count="10" returntotalrecordcount="true" {% if request.params['page'] %} page="{{request.params['page']}}" {% else %} page="1" {% endif %} >
 <entity name="EmployeeForm">
 <attribute name="empid" />
 <attribute name="employeename" />
 </entity>
</fetch>
{% endfetchxml %}{
 "totalcount": {{ feed.results.total_record_count }},
 "morerecords": {{ feed.results.more_records }},
 "page": {{ request.params['page'] | default: 0 }},
 "results": [
 {% for item in feed.results.entities %}
 {
 "empid": "{{ item.empid }}",
 "employeename": "{{ item.employeename }}"
 }
 {% endfor -%}
 ]
}

Result showing on Portal:

{ "totalcount": 0, "morerecords": false, "page": 0, "results": [ ] }

Can anyone please help, how to get data using liquid then show it on PowerApps Portal. 

Categories:
I have the same question (0)
  • timl Profile Picture
    36,383 Super User 2025 Season 2 on at

    Hi @sayyed007amir 

    Here are some comments that I would make:

    1 - To help diagnose the problem, it might be worth simplifying your fetchXML like so to see if that returns any data:

    {% fetchxml feed %}
    <fetch version="1.0" mapping="logical">
    <entity name="EmployeeForm">
    <attribute name="empid" />
    <attribute name="employeename" />
    </entity>
    </fetch>
    {% endfetchxml %}
    

     

    2 - I would replace EmployeeForm with the logical name of your entity - which would look something like xxxx_EmployeeForm

    3 - It looks like you're trying to use returntotalrecordcount="true" to retrieve a record count. This isn't supported, and there's an post that you can vote for here in the ideas forum.

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Support-ReturnTotalRecordCount-FetchXML-Attribute-in-the-Web-API/idi-p/223070 

  • sayyed007amir Profile Picture
    357 on at

    Thanks but this one code also showing blank white screen only.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard