Filter lookup field by date RRS feed

  • Question

  • I have two lists. First list is a list of courses with title and date. Second list is a registration list with name and lookup by course title. Is there a way to filter the lookup when you're trying to submit the form so that it only display courses that are not over yet?

    I tried using a calculated field of IF(Date>TODAY(), Course, "") but it would filter out the already added items in the lookup to blanks once it has passed and that's not what I want. I just want the dropdown to be filtered and if a registration has already been submitted, then it doesn't disappear from the column.

    Thursday, July 7, 2016 1:05 AM


  • Hi,

    According to your description, my understanding is that you want to filter lookup by date.

    I suggest you use custom solution to achieve your needs.

    Here is a demo about a custom solution:




    Best Regards,

    Andy Wu

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by Andy JY Friday, July 15, 2016 2:07 AM
    • Marked as answer by Patrick_Liang Tuesday, July 19, 2016 11:37 AM
    Friday, July 8, 2016 9:19 AM