Limit items in dropdownlist RRS feed

  • Question

  • HI everybody,

    Sharepoint Online

    I've ha list called ProjectList that store all our projects.

    The list have some fields such as ProjectName, ProjectID, Year, ProjectManager, and ProjectStatus.

    A second list called TimesheetList store the worked hours by everyone on the project. In the list there is a lookup field to ProjectList.ProjectName

    I've created a NewForm for the TimesheetList for recording individual timesheet and ther is a ProjectName dropdownlist.

    My goal is to show ONLY PROJECTS that have a status "In Progress", but the OOTB Sharepoint DropdownList shows me all!

    Now I remove the items via Jquery but the it will be better filter the data before. There is a way to modify the dropdown datasource with such a conditon, leaving the bindind to the control?

    Thanks to all



    • Edited by marcomac Thursday, March 23, 2017 3:25 PM
    Thursday, March 23, 2017 3:24 PM


All replies