Solved: Cannot compare List with Text - Page 2

TotalSolutions · 05-15-2023 06:33 AM

I have a Order Table and it has a Column StockItem which is a Ref to StockItem Table. In the Valid If I am puting the following formula so that Only the Stock Items that have Sub Module as Order will show up and I am using ORDERBY so it shows the Stock Items in Alphabetical Order:

ORDERBY ( SELECT ( StockItem [SIID], [SISubModule] = “Order”, [SIName] ) )

But it gives error as "Cannot compare List with Text in ([SISubModule] = "Order")"

Please let me know how to fix it.

Thank you 😊🙏

Suvrutt_Gurjar

Please try

ORDERBY ( SELECT ( StockItem [SIID], ISNOTBLANK (INTERSECT([SISubModule] , SubModuleOrder[SubModuleID]))), [SIName] )

View solution in original post

Suvrutt_Gurjar

Thank you for the update and good to know that it works. However from your latest post and the slice filter expression, you have shared, it sounds that there is only one row in the Sub Module table with "Order" as SM name, then the expression can be further optimized and you do not need a slice also. If there is ever only one row with "Order" as [SMName], then please try the following simpler expression. You do not need the slice also.

ORDERBY ( SELECT ( StockItem [SIID], IN("0388FFBC-4AC7-4EA6-8AAA-FEECCA0D0974" , [SISubModule]) ), [SIName] )

View solution in original post