Action Failed when Bloquer is selected

[eldderri]

Hi,

I have an action to block a truck in my table form ,but when I click on it it displays :

Action Faild with the message restricting adding truck when that truck is already blocked.

My column in checklist ,where I want to prevent duplicate truck checklist is set like that :

My action to block the truck is set like that:

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
)

Best regards,

[mateo]

Hey @eldderri,
I think the message inside the "Action Failed" pop-up is the one you specified in one of your columns' data validity section, which means that you are trying to update this column and the condition for its validity isn't met. Am I right?

Try to factorize your formula and check which condition returns FALSE.
What about this part: 

[Matricule Camion] = [_THIS]

Good luck 😉

[eldderri]

When I used your formula as follows:

I got this error:

[mateo]

I didn't mean to use this in your custom error formula. I was making sure that I understood the problem correctly. But thanks to this we know that this condition is met: [Matricule Camion] = [_THIS].

 I thought you would check all of your conditions in your IF() formula to find out which causes the problem. Did you try to factorize your snippet?

[eldderri]

I have changed my valid if formula to:

ISNOTBLANK(
FILTER(
"CheckList",
AND(
[Matricule Camion] = [_THIS],
[Action] = "Bloqué"
)
)
)

And add a virtual column named Status message withe the following formula:IF(
ISNOTBLANK(
FILTER(
"CheckList",
AND(
[Matricule Camion] = [_THISROW].[Matricule Camion],
[Action] = "Bloqué"
)
)
),
"Ce camion est en état de blocage",
""
)

And still not working