Expression Error in Validif

I have an expression in ValidIF. It works when I TEST it but returns nothing the app.

I contacted support and they told "Valid if only check the output but doesn't returns a value." 

"It is just to check whether the value is matched with the condition or expression."

"With drop downs it's different scenario."

So I had to send him help documentations so that he can understand appsheet can return as Yes/no,List. 

Then support told me they will look into the issue and contact me back and closed the chat. Does anyone know If i am doing it right ? Looks like a bug to me if I am correct.

Here is my code

 

SELECT(
			Product Bill of Materials[BOM Product ID], 
      
      IN(
        [Product Bill of Materials ID], 
        SPLIT(
        SELECT(
        			Sales Order Acceptance Items[List of Bill of Materials],
              [Sales Order Acceptance ID] = [_THISROW].[Sales Order Acceptance ID]
      
     				 ), " , " )
      	)
	
  		)

 

 

 

Screenshot 2023-03-07 at 1.16.22 PM.pngScreenshot 2023-03-07 at 1.33.13 PM.pngScreenshot 2023-03-07 at 1.32.41 PM.pngScreenshot 2023-03-07 at 1.50.24 PM.png

0 19 298
19 REPLIES 19
Top Labels in this Space