cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ParthParikh
Regular Visitor

How to populate records in Entity list from a Web template call

I have created a custom web template on my powerapps portal.

In my webpage, i have added a call to the Web template on the onload event of the webpage which returns a JSON Response of 10 records.

Inside the same webpage i have a list that show records(more than 500 records.)

 

How can I display only those 10 records from the JSON Response in the list?

 

 

The original problem i am trying to solve is as follows:

I have 3 entities:

1. Products(Custom Entity)

2. Contacts (oob Entity)

3 Locations(Custom entity)

 

They are linked in the following way:

Each product has a contact(lookup to contact entity).

Each Contact is associated to Location(Lookup to location entity).

 

Issue: I want to show a logged in portal user, the list of products that are linked to contacts who are based in the same location as the logged in user.

 

For example:

product 'A' is create by contact 'X' who is based in 'Canada'

Product A--> Contact X--> Location Canada

Product B --> Contact Y--> Location Canada

Product C--> Contact Z--> Location Canada

Product D --> Contact F--> Location USA

 

So, when Contact X navigates to a particular view/entity List on portal.. They see Products A,B,C as they are created by contacts based in location 'Canada'

 

Can someone please suggest how can I do that?

 

1 REPLY 1
eugenevanstaden
Helper I
Helper I

@ParthParikh 

You can add FetchXml in the Liquid to query the data server side, and build up a custom grid. 

If you configure the Entity Permissions then your FetchXml will be filtered based on those permissions/relationships.


Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel News & Announcements 768460.png

What's New in the Community?

Check out the latest News & Events in the community!

MPP IDEAS updated 768x460.png

Ideas

Discover ideas and concepts from users like you for how to use Power Pages and take your work to the next level.

Users online (3,858)