User table Lookup not returning results

(0) Share

Report

Posted on by Ray_Garza

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:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Lucas001 2,429 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Ray_Garza 143 on at

Like (1)

Report

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

Was this reply helpful? Yes No