Forum Discussion

Brass Contributor

Jun 01, 2020

Solved

MC211640: Conditionally show or hide columns in a SharePoint list or library form

After 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 msPr...

SharePoint Online

Vikram_Samal
Jun 01, 2020
lsittler As far I have tested this function only works in the display form not in Edit or New Form. Even they don't allow to save the formula as real time evaluation of fields are not happening.
See the below screen shots: 1. New Form:
2. In Display form It works:
3.Finally Display Form formula:
But you can use power-apps that will give you this feature. If I could help to find the solution, please like or mark the answer as solution.

Thanks
Vik

Vikram_Samal

MCT

Jun 01, 2020

lsittler As far I have tested this function only works in the display form not in Edit or New Form. Even they don't allow to save the formula as real time evaluation of fields are not happening.

See the below screen shots: 1. New Form:

2. In Display form It works:

3.Finally Display Form formula:

But you can use power-apps that will give you this feature. If I could help to find the solution, please like or mark the answer as solution.

Thanks

Vik

lsittler

Brass Contributor

Jun 16, 2020

Hi Vikram_Samal, thank you for your answer.
I understand that Power Apps is the solution to create custom form but I had hope that SharePoint could have a simple feature like this because the formula is available for the edit mode too.

It is complicate to explain to the final users that, yes you have a conditional formula but no it does not work like that.

Create a Power Apps for a simple use case like this one is pretty huge (potentially with authorizations, licences and external sharing).
Anyway, it is noted. That you for your time 🙂