SharePoint Filtered Lookup

#SharePoint #SharePointFilteredLookup #SharePointLookup
In this video, I show you a no-code way to create a filtered lookup in SharePoint. I'll walk you through creating a calculated column in your source list to return the filtered result set then creating a lookup column to that in your destination.

[philipgaudreault]

it's been a long time since I broke my head to get around this need ... Thank you very much. I have just taken a giant step forward ...

[fanzfanzilla]

It took me a long time to find your video to solve this problem: How to only show active items in the lookup from the SharePoint list. Wow! You are the best and thank you for sharing.

[FaaBioo]

Sometimes Universe tell you you're on the right way. Since some days I'm coming back to SharePoint, I always find a useful video from you April : starting from Lists to PowerApp through Flow etc.

That's incredible on this Friday, last day before my holidays, I found your 1st YouTube video 🥰

You're just an angel on my way to level up, so thanks a lot for that ❤️👍🏾
Thank you for sharing and keep growing, you are an inspiration 😇

Greetings from France

[lpapmarcial]

Thanks April. Simple and well explained. And yes, even in 2021 you can still find people who will need a great tip like this :)

[malayvasavada]

Wooho. I see what you did there. Smart. Thanks April for showing this. I was looking at this to solve one of the customer query raised today only.. I would say it was relevant not only back in 2018, it is so even in 2022. Thanks again.

[Mahmoudalgindy]

It's 3 years back, but still useful, thank April

[lv]

This was very helpful, one question, what happens to the records on which I selected an active value that is now no longer active?

[robh]

Oh wow! I just found this, your first YT video, had no idea. Really good video.

[juhakalliola]

Great and simple video and just what I needed. Anyhow I had to replace comma with semicolon to get it work. Somehow I don't manage to get the result blank as I need to. Instead all empty fields has text "No". What could cause this?

[ashleycamille]

Super helpful for the project I am about to start! Thank you, April!

[johnshield]

If anyone is wonder what happens when you change something from active to inactive in the source list, your lookup column value goes empty. However, SharePoint retains the lookup reference ID (i.e. the lookup isn't broken, the value is just empty), so if you add a second column pointing to one of the other lookup columns (see timestamp 3:36), it will still display this information.

[NeoEskrima]

Thanks for the video! A valuable demonstration of how recombination will create new effetcs in SharePoint. Great hack!

[lincolnjoseraad]

Hello April, thanks a lot to share your knowledge with us! Is it possible to create a cascade lookup with 3 columns (Countries, States, and Cities) looking in 2 others lists? E.g.: Countries, States, and Cities using a list for Country/States and another one for States/Cities? Thanks again.

[realfarmerjay]

Exactly what I was looking for! Thank you!

[christybohlman]

Hi April,
This was super helpful. I've tried it out, however I ran into a snag in that the Calculated column isn't updating when the 'Status' column is updated. Will the calculation not auto update? Would I need to update the calculated column using a flow?

[pteixeira]

Genius solution. Exactly what I needed. Thanks so much!

[barakathcs]

Awesome April, How do I use a lookup value in a calculated column? By default, lookup columns are not visible to choose. Any workaround other than PowerApps?

[shathike]

Hi April, 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 in SP List. Thanks

[gerardjuravich]

Great Video.  Couldn't find this anywhere!

[mikepeterson]

This is exactly what I needed! Thank you! :)