How to Use a Lookup Field Column in SharePoint Lists | Microsoft SharePoint | 2022 Tutorial
Вставка
- Опубліковано 30 вер 2024
- Hi Everyone,
In this video, I demonstrate how to use a Lookup Field column in SharePoint Lists. This is useful for connecting information from two lists.
More on Lookup Fields: support.micros...
If you enjoy this video like, comment, and subscribe.
✨Support My Channel✨
If you enjoy my content and would like to support my work, consider buying me a coffee! Your support helps me create more videos and keep the channel going. ☕💖
buymeacoffee.c...
🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin
#LookupField #SharePoint #SharePointLists
The most to the point best explanation of a lookup column I have seen yet and I have seen many, well done
Thanks John!
Can this be automated? I have a form that asks the person filling out the form their company. So based on that company (W1234) it will populate the parent company. I have the form connected to Lists via Power Automate. Basically need something similar to a VLOOKUP in excel.
I successfully brought in the first column from another list, but the additional columns from that same list won’t populate but greyed out? Do u know why?
Hi, if I have a look up column in SP list, how can I see more field in the drop down menu from another list data? For example I have a "A" list with look up menu and "B" list with 2 columns. So I create a new record in "A" list and open drop down menu, but I see only one column data from "B" list. I would like see in drop down from "B" list 1 and 2 column in "A" list. Is it possible?
That is exactly what I was looking for :) Thank you Michael for the great explanation!
Greets from Germany
I'm glad to help! Greets from USA
IS it possible to create a lookup column based on condition? (Lookup value based on value in other column (IF formula)? It's possible to create a calculated field but there is only the option to set the resulting value like text, integer, date... but not a list with options.
Thank you Michael, is there a way to lookup a drop-down choice column from a list? So far I can only copy from a "text only" type of column.
Currently, Microsoft only supports Single line of text, Number, Date and Time, and Lookup for a Lookup Field. You could use a Flow to copy the value of the Choice Column to a Single line of Text and then Lookup on that.
Thank you, it could be linked with a list from a different site?
Unfortunately, you can't link lists between SharePoint sites.
Hello & this is really well explained
But for me only 1 column details appear other column details are not appearing but headers are....
Hi Michael, this is good informative, kindly let me know, lookup field not working for date format its visible number format (i.e. 44,745) please guide me how to change as date format. Thanks
Thanks, that was useful. Can you lookup a list in another SP site or do all the lists have to be in the same site?
Must be in the same SharePoint site, currently
Hey, great video. Thanks for the tutorial. Do you know why after setting this up you cannot add new rows using the edit grid mode? only works when you use the +New button. thanks
Thanks for the video, great explanation. Do you know if it's possible to automate the relationship on both tables? So when I add say a resource to a task (on a List of tasks), I'd also like to see on the List of Resources, all the tasks associated with it. Airtable does this really well, interested to see if Lists can do something similar. Cheers.
This finally makes sense. Thank you
Another great video; if I wanted to create a onboarding process in Sharepoint can I also link it to another list?
What if one of them is in the form of a library list?
I have an issue where the name column is blank, but the lookup correctly populates the other cells. Is this an error on my part?
Is the column you are looking up a string or date?
Hi, excellent video as usual.
I need the lookup work based on a column in the current list. I.e. I don't want to select manually the contact name and based on that it returns the contact number.
I want to lookup a value in a column from the current list , look it up in another list and returns the needed columns.
Is this possible?
Thanks..
Yeah, you'll need to use a Power Automate Flow to look at the Lookup field and find the corresponding item. Then, update the item.
can you do 2023 version plsss..
Hello Michael! Very helpful and precise tutorial! I have a question, what if the person has 2 telephone numbers, is there a way to select which one do we want?
I would put the phone numbers in two separate columns (ex. Phone 1, Phone 2) and then select the column you want.