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?
Solved! Go to Solution.
Thanks for the answer. I had already changed the permissions in the SharePoint column, but apparently PowerApps had not registered it.
The solution for me was to re-create the exact same column, and then do as you mentioned with making it "required" in PowerApps and "Not Required" in the SharePoint list settings.
Thanks for your help 🙂
As I know, If your SharePoint column are required, So the data for that column can't be blank, regardless of any code you use on Power Apps because it's restricted by SharePoint.
I do recommend to set that column to be optional on that SharePoint list and use Required property for Datacard in PowerApps.
It's more flexible, then you can use this code on Required property of your Execution Project's datacard
DataCardValue18.Selected.Value = "Execution Project"
Thanks for the answer. I had already changed the permissions in the SharePoint column, but apparently PowerApps had not registered it.
The solution for me was to re-create the exact same column, and then do as you mentioned with making it "required" in PowerApps and "Not Required" in the SharePoint list settings.
Thanks for your help 🙂
User | Count |
---|---|
258 | |
108 | |
95 | |
58 | |
40 |