Forum Discussion
Solved
Show/Hide Fields Conditionally in SharePoint Online Custom List
Hi,
I'm hoping someone can help.
I'm aware that fields in an SPO Custom List can be displayed/hidden conditionally via the 'Edit Columns > Edit Conditional Formula' route on the New Form.
This seems to fall down though when a user accesses the Edit Form and changes their original answer to the trigger question. The dynamic questions are re-hidden (as per the conditional formula) but the answers previously provided to the dynamic questions (when they were visible) are retained in the list.
I need to find a solution that displays/hides fields conditionally, but that also removes previous responses from the list if the answer to to the trigger question is changed via the Edit Form.
If someone has a solution it would be much appreciated.
Thanks.
Matt9915 You can reset / remove values in one field based on selection of another field (in "OnChange" action) in Power Apps. Refer below threads for more information:
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.
Matt9915 Unfortunately, this is the default behavior of SharePoint list forms & conditional formulas. Condition formulas can only show/hide fields based on formula, it cannot remove previous responses/values from list columns.
You can use Power apps to customize the SharePoint list forms. Using Power apps, you can show/hide fields as well as remove previous responses/values from list columns based on selections in list form.
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.
- Thanks for replying ganeshsanap.
I have been able to find a lot of guidance on the internet around showing/hiding fields using Power Apps, but haven't been able to find anything on removing previous responses/values from list columns based on selections in another column.
Are you able to give me any guidance on how to do this? Or point me in the direction of a forum thread or blog that covers it?Matt9915 You can reset / remove values in one field based on selection of another field (in "OnChange" action) in Power Apps. Refer below threads for more information:
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.
