I am trying to filter a dropdown depending on what the user put just before (year of the article and quantity) in the form of the app.
I did like that:
SELECT(Products[Article Id], AND(IN([_THISROW].[Article Annรฉe],Products[Article
Annรฉe]),IN([_THISROW].[Article Quantitรฉ],Products[Article Quantitรฉ])))
My column is type ref and I put this formula in the suggested value. But the result gives all the column if I put a year that is in the column but I want just the article with this specific year.
Perhaps it is not clear, but do you have an ideaโฆ Here an example of the product table.
Solved! Go to Solution.
Try with the syntaxโฆ
SELECT(Products[Article Id],
AND(
[_THISROW].[Article Annรฉe]=[Article Annรฉe],
[_THISROW].[Article Quantitรฉ]=[Article Quantitรฉ]
))
I try like that:
select(Products[Article Id], AND([_THISROW].[Article Annรฉe]=Products[Article Annรฉe],[_THISROW].
[Article Quantitรฉ]=Products[Article Quantitรฉ]))
But it give me an error: Cannot compare Text with List in ([Order Details Id].[Article Annรฉe] = PRODUCTS[Article Annรฉe])
It is weird because I see this expression very often.
Try with the syntaxโฆ
SELECT(Products[Article Id],
AND(
[_THISROW].[Article Annรฉe]=[Article Annรฉe],
[_THISROW].[Article Quantitรฉ]=[Article Quantitรฉ]
))
Very nice, It is working. Thank you.
Youโre welcome
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |