Show/Enable fields based on drop down ( which is look up column )

Mohammad Qasim 576 Reputation points
2020-12-23T10:51:18.677+00:00

Hi,

I have created look up field and there is date field is well

Solution : I want to enable/active date field when drop down ( which is look up field ) text is "Applied for DAP" else not
Thanks

Below image for refence.

50764-activewhenstatus-darp.png

SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,377 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ChelseaWu-MSFT 6,241 Reputation points
    2020-12-24T02:40:06.013+00:00

    Based on the screenshot you provide; it seems that you are currently using SharePoint Online environment.

    You can customize the list form using PowerApps via Power Apps (on menu) > Customize forms and do as following:

    1. Select the Data Card for Applied Data field and then switch to Visible property under the dropdown menu.
    2. Change the formula to If(DataCardValue2.Selected.Value="Applied For DRAP",true,false), where DataCardValue2 is the Data Card for the Lookup field.
    3. Save and publish the form to SharePoint list. 50897-screenshot-2020-12-24-103033.png

    Here is the outcome:

    50905-powerapps-custom-form.gif

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    **Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. **