Unanswered

Filter not working on dropdown

(0) Share

Report

Posted on by jpjp

Hi there so I have come across a possible bug

I am setting a dropdown items based on a variable like below, and in some cases the first row is missing from the filter

If(RoleType = "Support Staff" Or RoleType = "XY Services",Filter('[dbo].[PayScale]',Type = "Support"),RoleType = "YYStaff",Filter('[dbo].[PayScale]',!IsMatch(Type,"Support")))

I can replicate this 100x by submitting a form when it is either a Support staff or an XY staff and then submitting a form with a YY staff. The missing row is only ever for a YY staff and I can submit loads of YY staff without issue, but as soon as I submit a form as another staff type then the next form will be missing the first row

P.S as to why I'm querying the DB each time I originally had a collection and filtered that and had the same issue, was trying something else to see if it would work

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Hi @jpjp

Could you try this and see if it works. I think the problem is with your !IsMatch()

If( RoleType = "Support Staff" || RoleType = "XY Services", Filter( '[dbo].[PayScale]',Type = "Support" ), RoleType = "YYStaff", Filter( '[dbo].[PayScale]',Type <> "Support" ) )

If there is no other option than YYStaff other then XY and Support staff then

If( RoleType = "Support Staff" || RoleType = "XY Services", Filter( '[dbo].[PayScale]',Type = "Support" ), Filter( '[dbo].[PayScale]',Type <> "Support" ) )

should be sufficient.

Was this reply helpful? Yes No
jpjp 40 on at

Like (0)

Report

Hi @Drrickryp

Just tried your solution... However sadly the same issue happens

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@jpjp

Is Type an option set?

Was this reply helpful? Yes No
jpjp 40 on at

Like (0)

Report

@Drrickryp

Nope just a varchar column in a SQL database containing a string

Was this reply helpful? Yes No