Unanswered

Filter formula not working.

(0) Share

Report

Posted on by CU06111240-0

In my current app, when a commodity is selected, I would like the item description to filter and show only the item descriptions from that commodity.

The formula that is being used for the commodity column (datacardvalue9) is

The formula I am using for the item description column is

I do not know why the formula is not working. Is there a different formula that should be used for a dropdown column that has a global variable? My overall goal is if you have commodity: Avocado, then the item description should filter to only avocado item descriptions. Please help me with this matter if you can.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Hi @tchamb2 ,

I am a little unclear what you are doing here and how/when varCommodity is set, but the top piece could be

Table( { Result: varCommodity, Value: varCommodity } )

and the second one

Filter( 'Conditioning Tool 2', 'Item Description' = varComodity )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CU06111240-0 83 on at

Like (0)

Report

The formula for the table is not working. For the previous page depending on the item selected decides the commodity selected. The formula that is used Set(varCommodity,"Avocado");Set(varconditioningday,"4");Navigate(EditScreen3,ScreenTransition.Fade)

For the commodity I added the next formula
If( varCommodity = "Avocado", {Result: "Avocado", Value: "Avocado"}, varCommodity = "Mango", {Result: "Mango", Value: "Mango"}, varCommodity = "Kiwi", {Result: "Kiwi", Value: "Kiwi"}, varCommodity = "Pear", {Result: "Pear", Value: "Pear"}, varCommodity = "Honeydew", {Result: "Honeydew", Value: "Honeydew"} ;Table( { Result : varCommodity , Value : varCommodity } )

For the item description I used

Filter( 'Conditioning Tool 2', 'item description' = varCommodity)

The Formula is not working.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@tchamb2 ,

I cannot progress this currently as you have simply repeated your first post. "Not working" also does not tell me a lot (do you get an error, or an unexpected result) and your commodity formula is unnecessarily complex (I gave an example of an alternative)

Was this reply helpful? Yes No