Unanswered

Distinct not working due to delegation issue with Sharepoint list in my power app

(0) Share

Report

Posted on by rachel007

I have 2 combo boxes.
Box 1 - Distinct list of States
Box 2 - Distinct list of Cities based on Box 1 selection

The combo box selections are used to filter my gallery items.

I had this working great using Distinct so that States and Cities weren't listed multiple times. However, now my db is over 2k and Distinct is not pulling in all the locations.

Does anyone have any other ideas on how to do this?
Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@rachel007
It's a little bit hard to picture exactly what your app looks like with no code or sample data provided but... do you have over 2,000 records for any state? If your answer is 'no' you do not have to be concerned about delegation.

Use this code in the Items property of your dropdown for cities.

Distinct(Filter(your_cities_list, State=ComboBox_State.Selected.Value), City)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
CU24091509-0 417 on at

Like (0)

Report
Copy link

Link copied!

@rachel007

Hello,

If i understood your question right,

Please follow this post https://powerusers.microsoft.com/t5/Building-Power-Apps/Combo-Box-with-Distinct-Lookup-Values/m-p/111513#M40085

if this doesn't work please let me know if you are available for a quick screenshare.

_________
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
rachel007 25 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Your code is exactly what I was using. There are over 2000 records. The person submits a form and part of the form includes city and state. City and State are my drop down filters for my gallery of items. If someone enters a new city at 2001, it won't show up as an option. Thank you for you suggestions. I should have added my code and more details.

Was this reply helpful? Yes No