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?
