1. What is the issue? Please be detailed.
fruits.csv (323 Bytes)
fruits.xlsx (12.1 KB)
In a form I have a repeat loop with 2 fields 1) a list that must be fed from an external file and 2) a free text field. I would like at each iteration the content of the list to adapt so that it no longer offers the elements that have already been selected during the other iterations. My actual case is not about fruit but I think the illustration will capture the problem. In my excel file there is a test in the choice-filter column but it has no effect. I have seen so many different proposals, sometimes based on intermediate variables with different syntax without any success. Thank you for your help and especially I don't want to put my fruits in the choice tab of the excel file. I place the 2 files (xlsx and csv) as attachments.
2. What steps can we take to reproduce this issue?
You have the file