Error message problem when recording with action

Pointer · 04-23-2021 03:15 PM

Despite the “Valid If” condition, I am saving a value that should not be in this column with action, I do not get an error message. What should I do to get an error message.

Marc_Dillon

Please show us what the expression is and what the values are.

Also, first time I heard someone asking how to get an error.

Pointer

[number] valid_if value;

IN([number], SELECT(Ordernumber[numbers], AND([column1]=[_THISROW].[column1], CONTAINS([_THISROW].[column2], [column3]))))

[numbers]=number from 1 to 25;

action: Data: add a new row to another table using values from this row

[number]: [number]+1 ;I add sequentially with this formula

I want [number] to be only in the range 1-25; Adding lines other than this value is not allowed.
I want to get an error message for this.

thanks

Pointer

Can anyone help?

Marc_Dillon

I can’t really make sense of your requirements.
However, to get this:

valid_if = AND( [number] > 0 , [number] < 26 )

Pointer

1-25 not fixed,

Ordernumber[numbers] there will be numbers on this list, if there is no number in the list, I want to get an invalid popup warning.

Marc_Dillon

What?

ISBLANK( Ordernumber[numbers] )
or
ISNOTBLANK( Ordernumber[numbers] )

Pointer

Ordernumber[numbers] Variable numbers based on ref value

ref for id 1([column1]) 1,2,3…25
ref for id 2([column1]) 1,2,3…16

Pointer

How do I add my valid_if formula this way?

IN([number], SELECT(Ordernumber[numbers], AND([column1]=[_THISROW].[column1], CONTAINS([_THISROW].[column2], [column3]))))

This formula works, I just don’t get a warning, it continues to add a row with action.

Marc_Dillon

^

Pointer

OK thanks