Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Answered

User table Lookup not returning results

(0) ShareShare
ReportReport
Posted on by 143

Hello Everyone,

 

I have a table called Applications and a column called SystemUser (lookup to User table). I want to pull up a list of people from the User table and assign a single person to the SystemUser column in the Application table. I have no filters on the Lookup, but I will eventually narrow the list of people to choose from.


When I run the application and edit a record, I select the Magnifying glass to pull up a list of people from the User table; I get the message:

There are no records to display.

 

What I've done:

  • Application table
    • User Column of type Lookup
    • Related table: User
  • Edit form
    • Permissions
      • Access Type: Global
      • Permission to: All options checked
      • Roles: Authenticated
    • Child Permission
      • Permission Name: Webteam List
      • Table: SystemUser
      • Relationship: cr94c_SystemUser_SystemUser_webapps_Application

I think I got it set up correctly. I'm all ears if there is another way to accomplish my objective.

 

Thanks,

Ray

Categories:
  • Ray_Garza Profile Picture
    143 on at
    Re: User table Lookup not returning results

    Morning @Lucas001 

     

    The table permissions suggestion is what worked. I would have not thought of that!

     

    Using Power Apps Portal Management, I went to Table Permissions and created a new Permission for the User table as shown below. Now, in the application, I see all the users! I just need to create a filter to narrow down the selection and I am good to go.

     

    Thank You for your assistance,

    Ray

     

    Ray_Garza_0-1695390107190.png

     

     

  • Verified answer
    Lucas001 Profile Picture
    2,216 Super User 2025 Season 1 on at
    Re: User table Lookup not returning results

    Hi @Ray_Garza,

     

    can you try setting up the permission for the user table as well?

    Append and Append to should be checked to all tables you are using.

     

    Try to insert a normal view of application and users somewhere in a test site. If you can see all records the lookup should see them as well when using the same permissions.



    --------------------------------------------------------------------------------------

    Hope that helps.

    If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 1

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 1

#3
surya narayanan Profile Picture

surya narayanan 35