Thanks a lot @PabloMFalero , the solution is not working but I think it is because inside an “Add Items” screen so it might be returning blank for the value I need.
I might need to modify the flow in order for “screen value” to return what I need.
The thing is that the choice list is coming up blank, that’s why I was wondering if I could place in a text the values for “vendor ID” and “screen vendor ID”
If it’s the second choice component in the screen, shouldn’t the filter be vendor ID is not screen’s first choice component value. Is that value available at all to you?
I believe it works normally in a form, not sure how it functions in an add environment.
I have an orders table and a products in order table linked by order id.
This is the “add items” screen for the products in order table.
On Choice #1 the user selects the order from the order table
On Choice #2 I want to only show products from the products table that match the vendor ID that comes from the order(vendor ID) table chosen on Choice #1
Unfortunately when I do this
It returns empty, that is why it would be awesome to be able to debug the values in order to understand what is going on, but I can’t find any way to print those values anywhere on the screen.
Again, if you have any suggestion I will super appreciate it.
Thanks for your time.
Currently to do this easily, you can use a detail screen by building whatever you need there. I’m going to sleep now, but tomorrow, unless my dear friend @ThinhDinh has already intervened, I’ll send you a working example.
Can you tell me if this same method for filtering a choice based on the selection in the first choice works with pages? I’ve been trying for days to get this to work in pages, but I was able to get it to work in an app the first time with no assistance.
When I add the filter to the second choice field (description) the choice field disappears. I’ve tried the entire method in other ways besides the form. Nothing works.
I refreshed and restarted my browser a few times, cleared cache, etc. tried in a private window, rebuilt the screen, form, and choice items again, but still experiencing the same issue.