User Profile
LabDude09
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Lookup data can't be pulled into a new list?
ThanksNorman YoungI look forward to your help. I did try to get a Flow to work, but all it did was put a batch code on a seemingly random Request entry, rather than the new one that was created. I couldn't figure out what went wrong so was unable to progress from there. I also tried using JSON formatting to grab the value and put it in a new column, which worked. But when I checked the box to grab data from the new field (copy of the lookup column data), it wouldn't bring it over to the analyse list. I tried other data points and they worked, so not sure what it doesn't like about the field being populated by JSON formatting.....Re: Lookup data can't be pulled into a new list?
Norman YoungThanks for the response - I have not thought of these options as I am still trying to understand how to work with Flows and its capabilities. If you have the time, is it possible to provide me with a few steps on how to go about either of these options as I am not sure where to start. In the meantime I will do my best to work out how. ThanksLookup data can't be pulled into a new list?
Hopefully I can explain this well enough along with the use of the below image: So I have the Analysis Request List (centre), which is like the mastersheet. The Container and Batch fields in this list, feed from their own respective lists via a Lookup. In turn, the Analysis Request list generates (automatically) a RequestID number. This number is referenced in the otherthree lists which are the various types of analysis that may be requested. I have been hoping to make it so that when I enter a RequestID number in an AnalysisType list, it pulls the Container and Batch information with it. Unfortunately this doesn't seem to work, because these two sit in the Analysis Request list as data from a Lookup. So it seems that you can use a Choice or Lookup from one list to another, but you are unable to reuse that data in a third list? This means I am unable to relate the data properly. I am looking into alternative ways to manage data within SharePoint (SQL database etc), but ultimately I am hoping to keep the interface side of things within the SharePoint UI. 90% of work is carried out within SharePoint and I am reluctant to have a solution that sits outside of it........Re: Send a Mail When a Field in a SharePoint List has a value of Yes
Rob EllisI realise this is an older thread, but I am just wondering exactly how to follow your instructions. I have completed everything as mentioned above but am probably to new to this to realise the steps needed. Do I create a new column in my list called 'FlowHasRun'? Is there a step in the Flow that actually sets the value of the column in the SharePoint list? Any help would be great thanksRe: Behavior change to look up fields in SharePoint list quick edit view
Greg GiesekeJust 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;Re: Behavior change to look up fields in SharePoint list quick edit view
As an update to this, I have started work this morning following all my usual steps with opening my SharePoint Lists, but for some reason when I open lists that don't contain any JSON formatting, they open in classic experience?? I don't know why, but using the lists this way, enables the Autocomplete function to work again..... So at the moment, as far as I can see, the issue I have been having is happening when editing a list in Modern view. While I prefer that I can continue using modern view over classic, at least I can now enter data efficiently. I would still say that this issue isn't resolved until it is possible for the Autocomplete function to work in Modern viewRe: Column Width in Sharepoint List
I had been looking into this a while back, and the best information I had found, was describing how to use a web part and java script to accomplish this. I was unable to follow it through as I don't have the right permission levels and had since given up on trying. I still believe that this is probably the only option at the moment. It involved downloading a piece of java script, uploading to the SharePoint site assets, then adding a web part. It didn't look overly complicated. If I manage to find the website that I was looking at, I will put more info in hereRe: Behavior change to look up fields in SharePoint list quick edit view
Just bumping this again to see if others have been experiencing the same issue. I unfortunately don't have any screen shots as proof that the behaviour has changed recently, but I have spent the last six months building lists and entering thousands of rows of data in, where I have been able to type it in and allow SharePoint to start displaying the closest match. I could then press the tab button to move to the next column/field. Given look up columns are designed to link lists together, and the possibility of these lists growing is extremely high, why would you want to be forced to scroll through thousands of data points in a drop down list every time you need to select data for the list you are in?Re: Behavior change to look up fields in SharePoint list quick edit view
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.Re: Behavior change to look up fields in SharePoint list quick edit view
Greg GiesekeThanks 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.Re: Behavior change to look up fields in SharePoint list quick edit view
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.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 bring up the list, to then scroll and select. This is very painful compared with being able to type in the first three to four characters and then select what I want without having to use the mouse. Is this a glitch with a recent update since the end of October, or a deliberate change? As it stands, this means that I have to manually scroll through a list of over 800 items on a number of fields as they are linked to other SharePoint lists. I don't think it is as much of an issue for drop-downs that have only 3-4 options in them, but this is not workable for Lookup columns that are referring to lots of data on other lists. I have tried three different browsers (Chrome, Mozilla and IE) with all three exhibiting the same behavior.
