Forum Discussion
Behavior change to look up fields in SharePoint list quick edit view
I have just started my working week to find that when trying to manually type in a value in a lookup field won't work anymore while in quick edit view. It is now forcing me to click with the mouse to...
Is anyone else experiencing this? Surely others are using lookup fields that link multiple SharePoint lists. I would really like to know if this is a bug that needs fixing, or if developers for SharePoint have decided that this is how lookup fields are going to work....Is there a place I should go to find info on latest updates, or is there a setting that I need to adjust? I can't seem to find anything to help at this stage. Any help or info would be appreciated.
LabDude09 - yes we started noticing this issues this week as well for both choice and lookup columns in SPO. Any resolution or workaround?
Greg Gieseke Just in case you haven't been keeping an eye on this discussion anymore, I have accidentally stumbled on a workaround. You can enter data as per normal (prior to the change a few weeks ago) by using classic experience. See my last reply for more info, but here is a screen shot to show what is happening with classic experience, that was happening while in Modern view;
LabDude09 - thanks for sharing a workaround.
Greg Gieseke Thanks for the reply but unfortunately at this stage there are no changes or workarounds. The closest I can come, is to copy data into the next set of rows that sits in close proximity to the data I need in the list that is being looked up (sorry if that doesn't make sense), and then go back and modify to the correct data. What would normally take me one or two minutes to add data to a list, is now taking upwards of 5-10 minutes, which is far from ideal in a work environment that is high paced. Hopefully it is temporary, but if anyone knows how to get the attention of SharePoint developers so that they can look into it, please let me know and I will follow it up with them.
LabDude09 - I opened a ticket and they claimed that nothing has changed and it has functioned this way for at least the past 3 years. They essentially claimed that me and my internal customers are misguided in how we thought the quick edit with choice and lookup columns used to work in quick edit just a few short weeks ago. Unfortunately whatever "didn't" change, changed in all sites and site collections so there isn't any way for me to prove otherwise.
Greg Gieseke- thanks for helping follow up on this. It is very disheartening to hear that this is their response....Could you please guide me as to where I can open my own ticket? I am thinking that if more people raise this directly, they may start to look into it, or perhaps acknowledge that something has changed.....
My only other thoughts, are whether a global setting has been changed by the administrator/owner of SharePoint account (I am not sure how all this works, but I would be surprised if the guys who oversee SharePoint for our company, would have bothered to alter any setting that would change something like this). I am still learning about permissions etc.I'm really wishing I had kept some screen shots of me working with my lists so we had actual proof....
Lastly, it doesn't make sense to me, for the lookup columns to behave the way they currently do. Why would you want to have to scroll through hundreds of rows of data to make one selection. The whole idea of a lookup column, is to link the lists (like tables in a traditional database) which I would imagine in most cases, are not small lists. A drop down selection, I can understand, but not a look up column.