Display error message when truck in data is Blocked

[eldderri]

Hi friends,

     I my app ,I want to display an error message under the column as soon as the number of truck appears to be blocked in my data table "Checklist". The column is named "Matricule Camion" .It is of type enum .The valid if property of this column is :

"Select(Camions[Matricule Camion], true) "

the column in Checklist table is named :Action and the value is "Bloqué"

How to do it?

Best regards,

[AleksiAlkio · Accepted solution]

One way is to move the existing formula from the Valid_If to Suggested values and then you can write a different evaluation with the Valid_If and show your own error message with it.

[eldderri]

I have applied the above steps and i get this :

But ,I want to display another message instead of invalid data entry ,for example: "Truck is already blocked".Is it possible?

[AleksiAlkio]

In your column's definition, under the Valid_If, there is an option called "Invalid value error". Write your own warning message there.

[eldderri]

Thank you so much.It's working now:

Best regards,

[AleksiAlkio]

You're welcome!

[eldderri]

Hi again,

     Unfortunately ,when I try to use "Bloquer le camion" action within the app it gives me this message: 

Here is my action;

Best regards,

[eldderri]

I think the problem may be with this expression :

IF(
AND(
IN([_THIS], Select(Camions[Matricule Camion], true)),
ISNOTBLANK(
FILTER(
Checklist,
AND(
[Matricule Camion] = [_THIS],
[Action] = "Bloqué"
)
)
)
),
FALSE,
TRUE
)

As when I tried to block the truck using the action the above message is displayed.