I’m trying to use the validation code to restrict a value in this scenario:

I have a prompt which has a formula and I want to validate the result based on the validation code column to show a warning message.

If the user interacts with the prompt, it triggers the validation and works fine, but when there’s no interaction, I can’t validate it.

Is there a way to trigger the validation with no user interaction?