Two filters, one gallery

(0) Share

Report

Posted on by R Bakker

725

Hi all

I have learned a lot, but I don't know how to code in the second filter to show only records that are greater than 0 in the reorder qty column.

Any help would be much appreciated.

Screenshot 2019-12-17 19.38.44.png Screenshot 2019-12-17 19.38.58.png

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @Corissandageri

You can update the expression as:

FIlter(Table1,StartsWith(Supplier, Dropdown_Sup.Selected.Result) && CQuantity > 0)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Thank you, but for some reason, I am still getting the squiggles under CQuantity. Telling me it's an invalid argument, expecting a number value.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Copy link

Link copied!
HI @Corissandageri ,

Could you please share more details about the error message within your formula?

Could you please show more details about the "CQuantity" column in your Table1? Is it a Number column or a Text type column?

I have made a test on my side, please consider modify your formula as below:

Filter( Table1, StartsWith(Supplier, Dropdown_Sup.Selected.Result), Value(CQuantity) > 0 )

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much, this worked perfectly.

Was this reply helpful? Yes No