Making a field mandatory based on another field in SP Modern list

Question

Making a field mandatory based on another field in SP Modern list

Harry N Nomikos 1,336

Hi Team

Is there way we can make a field mandatory based on a selection from another field on modern SP list?

Also, can this be achieved via conditional formatting under edit columns or would this need to be achieved in Power Apps?

Cheers

Accepted answer

1 additional answer

Your answer

Answer 1

Emily Du-MSFT 51,836 Microsoft External Staff

@Harry N Nomikos

You could set list validation to make a field mandatory based on a selection from another field in the modern list. For example, when test2 field =1, test1 field is mandatory.

1.Go to List settings -> Validation settings -> Use following formula.
=IF([test2] = "1", IF(ISBLANK([test1]), false, true), true)

2.Result.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2022-03-21T02:01:45.843+00:00

@Harry N Nomikos

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.
Harry N Nomikos 1,336 Reputation points

2022-03-28T23:47:46.967+00:00

Hi @Emily Du-MSFT

apologies for the delay, I'll give the above a go.

For some reason I can't load my Dashboard with all the questions I've raised on this forum and I've cleared my Cache and cookies...

Is there a way I can be notified via email when anyone responds to my question??

Cheers,
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2022-03-29T02:00:56.25+00:00

@Harry N Nomikos

Please follow the steps in this documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Harry N Nomikos 1,336 Reputation points

2022-03-30T07:24:42.927+00:00

Hi @Emily Du-MSFT

Thanks for the above, my dashboard is now working and I've turned on email notifications :)

I've tried the above formula and I'm getting this error "The formula contains a syntax error or is not supported."

The formula I put in is =IF(Action Status]="Sourcing", IF(ISBLANK([CC]),false,true),true)

Can you please validate my formula?

Cheers,
Harry
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2022-03-30T07:42:25.863+00:00

@Harry N Nomikos

Please use following formula. And what are column types of these two columns?

IF([Action Status] = "Sourcing", IF(ISBLANK([CC]),false,true),true)
Harry N Nomikos 1,336 Reputation points

2022-03-30T10:22:01.02+00:00

Hi @Emily Du-MSFT

The formula worked, thank you so much.
Harry N Nomikos 1,336 Reputation points

2022-04-05T02:17:25.79+00:00

Hi @Emily Du-MSFT

Would it be possible to have an If statement to say if the end user select "Yes" to this column "do you have more then 2 resources to hire" for the form to show an error message at the top of the form and prevent them from saving an entry?

Cheers,
Harry
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2022-04-05T14:12:12.533+00:00

@Harry N Nomikos

You could use following formula,.

=IF([do you have more then 2 resources to hire]="Yes", TRUE, FALSE)
Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2022-04-08T09:01:26.597+00:00

@Harry N Nomikos

I am looking forward to your feedback if there is any update.

Please remember to update this thread if you have any progress.

Thank you for your understanding.
Ehsan ElKhawas, Vodafone 0 Reputation points

2024-03-20T12:40:02.3733333+00:00

Hi,

if i can't see the calculated field/lookup field in the validation formula, is there a way to see them?
Siddrow 20 Reputation points

2024-06-17T04:58:42.1033333+00:00

Hi

How would I go about adding a second statement to this? I have tried the below, however it doesn't work.

If someone changes the status column to "completed" I then want the date completed and the % complete column to flag as required fields. The % completed column value is defaulted to 0%, so it would need to flag only if the value is less than 100%

=IF(Status="Completed",IF(ISBLANK([Date Completed]),IF([% Complete]<100),FALSE,TRUE),TRUE))
Vladimir Sazonov 0 Reputation points

2025-02-27T13:29:13.4666667+00:00

@Emily Du-MSFT , hello! Should this formula still work? I'm asking because I'm attempting to apply this formula in my MS List but always get "The formula contains a syntax error or is not supported".List.Formula.Issue.PNG

Answer 2

Harry N Nomikos 1,336

Hi @Emily Du-MSFT

Apologies for the delay, your help has been instrumental and I really appreciate all your effort with helping me find workarounds and solutions :)

Regards,
Harry

Share via

Making a field mandatory based on another field in SP Modern list

1 additional answer

Your answer