Dropdown Filtering not working

(0) Share

Report

Posted on by xzDan

350

This seems to work in Edit mode, not in live.

Very simple dropdown in a Form with 4 options, two of which end in 'start /end'.

Code for items is:

If(
 Edit_Form.Mode=FormMode.Edit,
 Choices(<Source>.Column),
 Filter(Choices(<Source>.Column),EndsWith(Value,"start /end"))
)

Again this seems to work fine when editing the app, but in live it will usually display all the options.

Am I missing something?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @xzDan ,

Could you please share a bit more about your issue?

Do you mean that the formula you provided could not work when you run your app in web browser?

I have made a test on my side, and don't have the issue that you mentioned. As an alternative solution, please consider take a try with the following workaround:

Set the OnVisible property of the Edit screen (which contains your Edit form) of your app to following:

If( Edit_Form.Mode = FormMode.Edit, ClearCollect(DropdownOptions, Choices(<Source>.Column)), ClearCollect(DropdownOptions, Filter(Choices(<Source>.Column),EndsWith(Value,"start /end"))) )

Set the Items property of the Choice ComboBox in your Edit form to following:

DropdownOptions

Best regards,

Was this reply helpful? Yes No
xzDan 350 on at

Like
a
(0)

Report
Copy link

Link copied!

Just that it does not seem to always work in the web browser. It used to work 99% of the time, and occasionally I would see all options become visible, but now it seems to not work 99% of the time. I will try your suggestion though, thank you.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @xzDan ,

Have you taken a try with the alternative solution I provided?

Have you solved your problem?

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,

Was this reply helpful? Yes No
xzDan 350 on at

Like
a
(0)

Report
Copy link

Link copied!

I will try it out later today!

Was this reply helpful? Yes No
xzDan 350 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft Thanks a lot!
Out of interest, is there a reason why this does not work the way I did it? I have had an issue similar to this before (can't recall off the top of my head) where I had to have a collection instead of doing a check similar to the problem here. I take it this should not be the case - perhaps a bug?

Was this reply helpful? Yes No