Get value of enumlist and compare it to a value in another table

So, I have a table called Picking. In this table I have an EnumList of invoice numbers coming from a Virtual column that has been split so that it can be properly indexed. I want to get the value from this EnumList so that I can look for it in a table called Invoicing. Now I am using the action, "Execute an action on a set of rows" from the Picking table to the Invoicing Table, and the referenced rows formula is as follows

https://ibb.co/Svjf866

The line in orange is not working, and that formula is not correct because I want it to single out the invoices that were picked in Enumlist and look for them in the Invoicing table 

If there's a better way of achieving this, please let me know as I am stuck

https://ibb.co/qJ9vzQ8

https://ibb.co/7tg6DzZ

https://ibb.co/C1T6fWs

Also, I have a looping action that converts Enumlist to Rows to a third table called Dispatching. I got that part to work.

here are the tables

https://ibb.co/3F3X4jQ

https://ibb.co/RcbP6Fy

 

 

Solved Solved
0 2 220
1 ACCEPTED SOLUTION

I found the solution thank you

on the orange line, I ended up using 

IN([Invoice Number],List([_THISROW].[Picked Invoice Number]))

 

View solution in original post

2 REPLIES 2

I'm trying to follow this but finding it difficult.  If you can try to explain the business problem you're trying to solve, it might help.  

I found the solution thank you

on the orange line, I ended up using 

IN([Invoice Number],List([_THISROW].[Picked Invoice Number]))

 

Top Labels in this Space