Forum Discussion

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Jul 05, 2023

    yenijc Unfortunately, you cannot customize the grid view in SharePoint online modern experience to show the lookup options dynamically.

     

    Are you trying to filter lookup options based on column in lookup parent list or column in same (lookup child) list where you are using grid view?

     

    Check my answer given here if it helps: Filter lookup column value using JSON 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    • yenijc's avatar
      yenijc
      Copper Contributor
      Jul 05, 2023
      I'm trying to filter it based on the column in same list.
      • ganeshsanap's avatar
        ganeshsanap
        MVP
        Jul 06, 2023

        yenijc Unfortunately, you cannot achieve your requirements using SharePoint out of the box functionalities for customizing SharePoint list grid view.

         

        If you want Microsoft to provide any such functionalities in future, you can add new feedback/idea on SharePoint feedback portal at: SharePoint Feedback Portal 

        Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • LeonPavesic's avatar
    LeonPavesic
    Silver Contributor
    Jul 05, 2023

    Hello yenijc,

    Unfortunately, native filtering of lookup options based on another column is not supported in SharePoint grid view.

    However, you can explore alternatives such as creating a custom form using Power Apps or SharePoint Designer, using calculated columns, implementing cascading dropdowns with JavaScript or third-party solutions, or building a custom SharePoint Framework (SPFx) extension, but these workarounds require advanced designing skills and investment.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    Kindest regards

    Leon Pavesic

     

  • yenijc's avatar
    yenijc
    Copper Contributor
    Jul 05, 2023

    ganeshsanap and LeonPavesic 

    I see.
    I wanted to use the grid view in adding/updating items. I'm also not using the list form. Guess there is no OOTB workaround for this.


    Thank you so much for answering!

Resources