Limit choices depending on another column in SharePoint

Occasional Visitor

Hey all, I'm currently working on a list in which for every item I have a Calibration Result, which tells me if a gas detector passes, doesn't pass, or if the calibration wasn't done. And then I have a 'Condition' column which is meant to justify the first column i mentioned.

image.png

Is it possible to limit the choices of the second column based on the first column's answer? I need for example for the Condition column to only show the 2 red background choices if the first column also has the red background choice (Doesn't pass). Thanks in advance.

1 Reply

@FrancoMoraENAP the only way you could do this is to have a Power Apps custom form and add cascading dropdowns.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)