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 Pages / Lookup Id in an entity...
Power Pages
Answered

Lookup Id in an entity form added to portal does not show all records.

(0) ShareShare
ReportReport
Posted on by 14

I have an entity called application whose form users can use to fill their application for a course they want to avail.
I have added the form to a power page portal

Prayat_0-1698649669878.png

However in the form there is a lookup field called applicant which is a lookup field from Leads table

Now when i open the form in crm im getting list of all leads to choose from when i select the applicant field in the form .

Prayat_2-1698650118910.png

 

However, when I check the power page portal and select the applicant field in the portal form It does not show all the leads and only shows those leads in the list for which application is already created.

No matter what view I use and also I have given all permission as well for the child attributes, I am still getting only those leads in the list for which application is already created.

Prayat_1-1698650057423.png

So i wanted to know what can be a viable solution that I can try to resolve this.

Categories:
I have the same question (0)
  • Verified answer
    ragavanrajan Profile Picture
    7,044 Most Valuable Professional on at

    Hi @Prayat 

     

    I would solve this in the following way. 

     

    Method 1: 

    1. Create a new table permission for the "Leads table" set a Global scope and set your privileges probably all ticked (Read, write,append,... etc..) to test it out. 

     

    In design studio  > Sync > press "Ctrl+f5" 

     

    Method 2: 

    1. In your "Application form" turn off all the filtering / filter-related records. 

    2. Use XRMToolbox fetchXML builder and link the "Leads" table and filter and see the results. If you are getting the desired results then most likely it is the permission issue. 

     

    Have fun. 

     

    Hope it helps.
    ------------

    If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

     

  • Prayat Profile Picture
    14 on at

    Thank you @ragavanrajan for the quick response.
    This solution actually worked for me. 

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Pages

#1
Suriyanarayanan V Profile Picture

Suriyanarayanan V 39

#2
oliver.rodrigues Profile Picture

oliver.rodrigues 28 Most Valuable Professional

#3
Fubar Profile Picture

Fubar 20 Super User 2026 Season 1

Last 30 days Overall leaderboard