Unanswered

Edit form and SharePoint list with lookup columns

(0) Share

Report

Posted on by Ronit05

Hi
I'm building an app from SharePoint list that have a few lookup columns.
When I want to edit a record that appears in the powerapp, those fields aren't editable.
Another fields in this form, which aren't lookup, I can edit.
What can I do to solve this issue.
Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

Hi @Ronit05 ,
A the primary lookup column is editable in a drop-down or Combo Box and this should be provided when you insert the field into an edit form.
If you are referring to a "secondary" lookup (show more fields from another table), then these are not editable as they are automatically generated based on the first.
If you are having issues beyond this, can you please send a screen shot of what you are trying to do.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Ronit05 5 on at

Like (0)

Report

Hi
Thanks for your answer.
I have a few sharepoint list that I made lookups to my main sharepoint list & this list I refer in my app.
Do you have a solution, how I can edit those columns in the app?
(I have a few lists, because all the data is from SQL, and we export to excels and import them to sharepoint lists.)
Thanks
Ronit

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

Hi @Ronit05 ,
The idea of a lookup to another list for an additional column (again I assume this is what we are taking about - please confirm) is essentially a formula that is updated when the primary lookup field is changed.
The only way would be to have a text field containing these values, which obviously would be editable.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Ronit05 5 on at

Like (0)

Report

OK thanks

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (1)

Report

Thanks @Ronit05 ,

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
amodtiwari 66 on at

Like (0)

Report

Hi,

facing issue with default value of primary lookup to set at edit form. could you please suggest any option.

i have used a dropdown control rather than using combo box in power apps.

please suggest.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

@amodtiwari ,

This is an old post, but you if you must use lookup columns (they are not necessary in with Power Apps), you need a Combo Box (and then it is not easy if you have changed the Items away from Choices(FieldName))

Was this reply helpful? Yes No