IN() Expression help

[AntonyCole1979]

I have 2 tables connected by [Order ID]. The Order Requests table (Parent), and the Order Request Details table (Child). I need to write an expression in a behavior action in the Child table to only be visible based on a value in the parent table. The parent table column is [Order Status] which needs to be =“Order Received” in order for the action in the Child table to be visible. [Order Status] in the parent table is a list. I’m having trouble trying to write an expression for this, please can someone help?

[Steve]

For the If this condition is true property of the action, try:

IN(
 "Order Received",
 [Order ID].[Order Status]
)

[AntonyCole1979]

Thanks for your help, but that did not work. I’m getting Parameter 2 of function IN is of the wrong type? Looks like I may have something wrong on the last part?
IN(“Order Received”,Order Requests[Order Status])
This seems to be close but then when another record is created and has the same value “Order Received” the action becomes visible again on all records?

[Steve · Accepted solution]

You said the Order Status column value is a list, but the error you got says otherwise. Try this instead:

AND(
 ISNOTBLANK([Order ID].[Order Status]),
 ([Order ID].[Order Status] = "Order Received")
)

[AntonyCole1979]

Thanks for your help, that seems to have worked for me, Antony

[soklyp]

Dear @Steve !

I need you help ,I have 2 function in columns valid if ,

Please show me what to do, Thank you for support me..