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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Power Apps Portal Look...
Power Pages
Unanswered

Power Apps Portal Lookup Field on Insert (create) form not displaying all records in the lookup

(0) ShareShare
ReportReport
Posted on by 4

Power Apps Portal Lookup field on Insert (create) form is only displaying 3 of the records regardless of the view (the search does not return anything).  The exact lookup and views work perfectly on the Edit form (all of the records display and the search returns results).  Any thoughts or suggestions?

 

 

EDIT FORM:

EDIT FORMEDIT FORM

 

INSERT FORM:

INSERT FORMINSERT FORM

Categories:
I have the same question (0)
  • Christian Leverenz Profile Picture
    1,214 on at

    Hi @Scott_Sullivan ,

     

    do you use filtered search (can be set on the form "show only related data") and the relation filter field is may be not properly filled on creation?

     

    Do you use the same roles and tablepermisisons for create and update (usually, they are the same but i never tested what happens, when i create two tablepermissions for the same entity and assign them to the same role).

    I assume, that the same user is logged in (or both time anonymous) for create and update.

     

    Just ideas,

     

    Have fun,

      Christian

  • oliver.rodrigues Profile Picture
    9,482 Most Valuable Professional on at

    In your dataverse form definition (for the Insert/Create) form, can you navigate to the classic view:

    OliverRodrigues_0-1643795031020.png

    then double click on your lookup field and check the Related Records Filtering:

    OliverRodrigues_1-1643795054108.png

     

  • Scott_Sullivan Profile Picture
    4 on at

    Thanks for the response.

    I'm not using any filtering, it is the same user (myself).

    I've logged a ticket with MS support, what I have found is if I create a new page (and add the same form) the lookup will work on about one out of five new pages. (I found this while randomly creating new pages during troubleshooting).  I'll update this once we hear back from MicroSoft, we captured a working and no-working example and sent it to them.

  • Scott_Sullivan Profile Picture
    4 on at

    Thanks for your response.

    I'm not currently using any filtering, I've added a reply to the previous post.  I'll update once I hear back from MS.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 42

#2
omkarsupreme Profile Picture

omkarsupreme 24

#3
Valantis Profile Picture

Valantis 22

Last 30 days Overall leaderboard