Lookup field locked

Like (0) Share

Report

Posted on 28 Nov 2024 15:23:40 by CU28111505-0

Hello All,

I have two tables: 'Table A' and 'Table B'

Also i have two security Roles. 'Security Role 1' gives full access to 'Table A' and 'Security Role 2' gives full access to 'Table B'.

I have created a lookup column in 'Table B' with a relation to 'Table A'.

I have placed the lookup field on the form in a model driven app. When i type something in this lookup field, related records from 'Table A' are shown. If i select any record from lookup, related data will be fetched from the 'Table A' and a java script populates these data into other fields on the form.

When i am opening the application in 'Play' mode using the account i used to develop, lookup field is working fine.

But when other user try to login and access the form, the lookup column is locked(read only).

I have a lot of dependency on this lookup field downstream.

I tried to provide Append permission. But that didn't help.

Please could anyone help me on this.

Thanks in advance.

Categories:

Power Apps component framework

Application Lifecycle Management (ALM)

Power Platform Build Tools

test.png

All responses (2)

Answers (1)

Suggested answer

CU28111505-0 2 on 05 Dec 2024 at 07:23:36

Like (0)

Report

Lookup field locked

In security roles, On both the tables, i have enabled the Append and Append to permission. This has resolved the issue.
Verified answer

MichaelFP 1,831 Super User 2025 Season 1 on 03 Dec 2024 at 11:49:45

Like (0)

Report

Lookup field locked

The other users. they have the same permission like you have? it look like the is missing the permission for the user because no correct role was assigned to the user.

To validate if is missing security role, disable any business rules and javascript code. if after that still locked it is missing security role. If not, maybe you need to check you business rules or the javascript used on that field or form.

If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as answer ✔️. This is help the community.