Hello,
I am building a SharePoint list using Power Apps to help input correct data.
I have created a dropdown that is visible if Type Of Project = Execution Project
If it not an Execution Project, the selected dropdown will be hidden.
However the drop-down is mandatory, and I would like it to be mandatory only if visible.
Currently I am not able to save if I select something that isn't Execution, as the required field is now hidden.
How do I ensure that this drop-down is required ONLY if DataCardValue18.Selected.Value = "Execution Project"?
I've tried the following: If(DataCardValue18.Selected.Value = "Execution Project",true,false)
I have also tried making two statements
If(DataCardValue18.Selected.Value = "Execution Project",true) OR If(DataCardValue18.Selected.Value = "New Product Development",false)

However I do not seem to be able to crack this. Does anyone have any ideas?