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

[ParthParikh]

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?

[eugenevanstaden]

@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.