Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Thursday, October 4, 2018 9:40 AM
Hello,
I have the same problem as the website below.
http://howididit-sharepoint.blogspot.com/2012/04/filtering-lookup-columns.html
I want effects that allows one list having a column connected to another list, but the drop down list should meets some conditions. So, does anyone have any solutions? I try the solution in upside website, but the problem still be unsolved.
Hope someone to provide some detailed solutions.
Thanks a lot.
All replies (6)
Friday, October 5, 2018 8:48 AM
Hi mollychen,
We can filter the lookup column by creating the calculated column.
Per my test in my SharePoint 2013 environment, there are two lists “list7” and “list8”. In the list7, there are columns “Titile” and “Test1”. And then I create the calculated column “cal1”, the formula of the “cal1” column as below:
=IF(AND(Title="aa",test1="test1"),Title,"")
The result as below:
And then in the list8, I create a lookup column to lookup the “cal1” column in the list7. Then when I add the new item, it will only display the “aa” in the lookup column. The result as below:
If you want to add some conditions to filter the lookup column, you could add these conditions in the calculated column.
For more detailed information, refer to the articles below.
Lookup filters in SharePoint works out of the box.
http://www.balestra.be/2014/05/hidden-gem-ootb-lookup-filtering-sharepoint.html
Calculated Field Formulas.
/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v%3Doffice.14)
Best regards,
Sara Fan
Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].
Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.
Monday, October 8, 2018 9:48 AM
Hi mollychen,
If the reply is helpful to you, you could mark the reply as answer. Thanks for your understanding.
Best regards,
Sara Fan
Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].
Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.
Tuesday, October 9, 2018 4:01 AM
Hi,Sara Fan
The record would be disappear, so is there any else solution?
There is a column named status in the project list. And there is a column provided for selecting project in Test List. But when the project be closed(status = no), the history record (the project column) in Test List would become blank. I need to reserve the record to analyze data in the future.
Is there any solution available? Thanks.
Thursday, October 11, 2018 2:22 AM
Hi mollychen,
You could create the calculated column. And then lookup the calculated column in another list.
There is no business with other columns.
Best regards,
Sara Fan
Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].
Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.
Thursday, October 11, 2018 3:39 AM
Hi,
Sorry. I can't understand.
Because my account still not be verified, I can't post picture.
I write the problem I meet bellow.
one List named Project:
projectname status calprojectname
project1 Y project1
project2 Y project2
the other list named TestList(projectname lookup calprojectname in Project)
projectname personId
project1 s001
project2 s002
project1 s002
When I change the status of project2 to N in Project List.
Project(after changing status)
projectname status calprojectname
project1 Y project1
project2 N
The TestList will become
projectname personId
project1 s001
s002
project1 s002
**But I don't want the project2 record in my TestList disappear. **
Is any solutions? Thanks.
Friday, October 12, 2018 2:00 AM
Hi mollychen,
You could use custom solution for filtered lookup column below.
sharepoint-2013-filtered-lookup-field.
https://github.com/hasangok/sharepoint-2013-filtered-lookup-field
Best regards,
Sara Fan
Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].
Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.