Forum Discussion
lsittler
Jun 01, 2020Brass Contributor
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...
- 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
Jun 01, 2020Steel Contributor
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
Jun 16, 2020Brass Contributor
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 🙂