> ## Content Index
> Fetch the complete content index at: https://blog.lsonline.fr/llms.txt
> Use this file to discover other available public pages before exploring further.

# Configure dynamic fields on your SharePoint Forms
- URL: https://blog.lsonline.fr/2020/06/18/configure-dynamic-fields-on-your-sharepoint-forms/
- Published: 2020-06-18T03:20:53.000Z
- Updated: 2026-01-27T18:54:04.000Z
- Description: A method to configure conditional columns to show or hide one of them in a SharePoint list or library form without Power Apps
- Author: Laurent Sittler
- Tags: SharePoint Online, Modern Experience, Getting Started

If you have already wanted to create some dynamic fields into the SharePoint item form in accordance with the selected value from another field, you have often been forced to use Microsoft Power Apps due to this kind of use case... How about if I tell you that for some very simple use cases, it is possible without Power Apps?

Almost every week, sometimes during several days, Microsoft rolls out new features for SharePoint Online and other Microsoft 365 services. It is not easy to follow all new features and sometimes the smallest ones can become really useful like the update feature **Conditionally show or hide columns in a SharePoint list or library form**.

Until now, when you wanted to configure which column had to be displayed in accordance with a value from another field, the only choice was to use Power Apps.

[Customize a SharePoint list form - Power AppsUse Power Apps to customize the form with which users create and update entries in a SharePoint list.Microsoft Docstapanm-MSFT![](https://docs.microsoft.com/en-us/media/logos/logo-ms-social.png)](https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form?ref=blog.lsonline.fr)

Here an example of a use case:

- A **mandatory** column of type *Choice* named **Provider**. The choices are:  
  - Microsoft
  - PnP Community
- A column of type *Choice* named **MSProducts**. List of several Microsoft 365 services
- A column of type *Choice* named **PnPProducts**. List of several products provided by the PnP Community
- When the **Microsoft** value is selected from the *Provider* column, the *MSProducts* field has to be displayed and the *PnPProducts* hidden
- When the **PnP Community** value is selected from the *Provider* column, the *PnPProducts* field has to be displayed and the *MSProducts* hidden

## Steps of configuration

1. Create a new item to the list
2. Once created, open the display panel by clicking on the title (by default)
3. From the header of the panel, expand **Edit form** and click on **Edit columns**

![](https://blog.lsonline.fr/content/images/2020/06/LsOnline-EditConditionalSPForm-1.jpg)

1. From the panel of columns, hover onto the target column (MSProducts) and *click on the ellipsis*
2. Click on **Edit conditional formula**

![](https://blog.lsonline.fr/content/images/2020/06/LsOnline-SP-Edit-CondFormula.jpg)

1. From the dialog, enter the following formula: `=if([$Provider]== 'Microsoft', 'true', 'false')`
2. Click on **Save**

![](https://blog.lsonline.fr/content/images/2020/06/LsOnline-SP-FieldColumn-mscase.jpg)

1. Edit the Conditional Formula of the other column (PnPProducts)
2. Enter the following formula: `=if([$Provider]== 'PnP Community', 'true', 'false')`
3. Click on **Save**
4. Click **Save** from the panel

For those who are curious and want to know why we are currently editing the *Display form* rather than the *Edit form*, I do not have any logical explanation ??‍♂️??

Before writing this post, I tried to configure the Edit form but the formulas were not valid...

[MC211640: Conditionally show or hide columns in a SharePoint list or library formAfter several attempts to operate a conditional field on item form, the formula still invalid. The use case is the following one: 1 column Provider, type Choice with 2 values 2 other columns msProducts and pnpProducts, type Choice When the provider is equals to Microsoft, the column msProducts shou…![](https://gxcuf89792.i.lithium.com/html/assets/favicon2.ico)TECHCOMMUNITY.MICROSOFT.COMLaurent SITTLER![](https://gxcuf89792.i.lithium.com/t5/image/serverpage/image-id/195825iB1B311659F665AC0?v=1.0)](https://techcommunity.microsoft.com/t5/sharepoint/mc211640-conditionally-show-or-hide-columns-in-a-sharepoint-list/m-p/1431279?ref=blog.lsonline.fr)

From now on, if you create a new item, in accordance with the selected value from the Provider field, the *MSProducts* or *PnPProducts* will appear and all without a Power Apps form. How cool is that? ???

![](https://blog.lsonline.fr/content/images/2020/06/Show-Hide-SP-Field-Form.gif)

SharePoint show/hide columns in list form demo

> \[note\]**Note**  
>  
> If you select a first provider and choose a MSProduct then change the provider and select a PnPProduct, both will be defined when you save the item.

---

Reference:

[Show or hide columns in a list formCustomize which columns to show or hide using a conditional formula in the list form by constructing a simple formula that are equations performing conditional checks on values in a SharePoint list or library.Microsoft Docsspdevdocs![](https://docs.microsoft.com/en-us/media/logos/logo-ms-social.png)](https://docs.microsoft.com/en-ca/sharepoint/dev/declarative-customization/list-form-conditional-show-hide?ref=blog.lsonline.fr#specify-conditional-formula-to-show-or-hide-columns)

> \[note\]**Note**  
>  
> All column types are supported except:  
> \- Person columns with multiple selections  
> \- Time calculations in DateTime column  
> \- Currency columns  
> \- Location columns  
> \- Calculated columns  
> \- Managed Metadata columns

Hoping this post will help you ?