ComboBox Condition Filter

[Anonymous]

This is the condition I have now. It defaults the User's home location in the ComboBox and then ALL other Location in the System. I only want the User's home location AND all other Locations in Region of that Location.

     Filter(SortByColumns(ParkListCollection.Park, "Title", Ascending), Title = varParkAlpha)

I changed the above to the following. This returns ONLY the Locations in the Region where the User is Located, which is what I want; however, it doesn't default the User's home Location in the ComboBox; which the first condition above did do.

     Filter(SortByColumns(ParkListCollection.Park, "Title", Ascending), "NPSReg" = varNPSReg)

How do I right the condition to do both default the User's home Location in the ComboBox AND only show Locations in that same Region?

[WarrenBelz]

@Anonymous ,

Have a look at the code now - dangers of free-typing when I am not able to test, however (and this is something for your learning journey) I would have hoped you would have picked up the omission as Ascending can only be used in a sort command. Please confirm if this works now.

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.

[Anonymous]

I apologize for missing the obvious, ol' wise one. I'll sharpen my eye. In the meantime I've got this now...

ComboBox

Items -

SortByColumns( Filter(ParkListCollection, NPSReg = varUserData.NPSReg), "Title", Ascending)

DefaultSelectedItems -

{Title: varUserData.Park}

The system recognizes I'm the User and display my correct Location and Region. However, the ComboBox does not default the name of my Location nor does it allow me, as ProgramHierarchy 'National', to search through the other Location Agency-wide.

The ComboBox is set to Searchable = "Yes", yet nothing appear when the box is expanded.

[WarrenBelz]

@Anonymous ,

As you can understand, I can neither see your model or data, nor test it and I have also assumed some things due to them not being completely clear to me from your posts, so some basic debugging with assistance from you is required.

Firstly, you have gone back from the Collection to the old code (any reason?), however looking firstly at your latest  code

SortByColumns( 
   Filter(
      ParkListCollection, 
      NPSReg = varUserData.NPSReg
   ),
    "Title", 
    Ascending
)

has to produce data if varUserData.NPSRegion has some matches in ParkListCollection.NPSRegion, so the first thing is to put a label on the screen with varUserData.NPSRegion  and see what value it is returning and then look at your Collection (View > Collections> ParkListCollection) and see what is in NPSRegion (you will only see the first 5 entries).

As to the DefaultSelectedItems - do the same with a label for varUser.Park

Then look in View > Variables > varUser and see what is in there.

Finally please take a few minutes to read this blog on forum posting - you might understand a bit better the challenge.

After all of this, can you please give me your opinion on what you think may be wrong - this needs two minds working on it to resolve quickly.

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.

[Anonymous]

Warren, I understand! And, I appreciate all you effort, in while blinded by distance.

Though it may not appear so, I am analyzing everything you send and studying information continually. Though it is hard to dig and hole and spend time reading about how to dig a hole at the same time.😁  I volunteered to do this; folks here are expecting me to dig, not learn too dig. Consequently, the effort is more complicated than necessary. It is the bed I've made.

Again, thank you for your time!

See labels below. I don't believe I saw instruction to create a variable for varUser in the previous instructions.

Another complication is in the naming of the Locations (Parks) and the Regions. It is NIFC that may be complicating the matter. I am adding to the choices, where a particular group will now be UNAS (for 'unassigned') rather than NIFC.

I'll them update everything and see if the result is different. Please standby...

[Anonymous]

Made all the updates.

The ComboBox defaults to my home Location, but it doesn't expand to show me any other locations.

Its as if I am limited to only seeing the default; which was not the case with the original condition. 

All boxes that I created to verify proper variable operation do contain the appropriate default content (except the varUserPark box - see below).

Also, I still have a box standing by for content of varUserPark; which, again, I don't ever think I was instructed to created.

Is this box still necessary and what condition should populate it?

My wife is calling me for dinner. I'll be at it again fresh and early in the morning.

[WarrenBelz]

OK @Anonymous ,

You have varUserPark.Park, not varUser.Park

Secondly, what field are you displaying in the Combo Box - I gave you colRegions as the Items, but you need to set the field to be displayed in the panel at the right when you select Edit. An alternative is if the field is (for example) Location, you can set the Items to colLocation.Location.This honestly should not be hard to resolve as you want a simple list for a dropdown - the testing you can do is as I mentioned, but also after you run the collection code, put a label on the screen with CountRows(colLocation) and see how many items are in it.

Sorry, but I have to ask another question that comes from your "digging holes" analogy - did you write this or have you picked up someone else's problem to fix?

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.

[Anonymous]

Good morning!

You are correct, I had varUserPark.Park. I changed it to varUser.Park. However, I still can't find where you instruction are to set varUser.Park or where in the screen I should place it.

The ComboBox DisplayFields is currently set to {"Title"].

To your last question; this is a mess of my own making; well the help of several in here...including yourself, sir. Thank You!

Finally, I placed a label with CountRows(colRegionsCollection) on the screen. I also placed a button with (ClearCollect(colRegionsCollection,MermberList).

With everything place the label for CountRows(colRegionsCollection) content was '3'. When I pressed the button the CountRows(colRegionsCollection) content went to '817', which is the actually number of Members on the MemberList. No configuration has provided me 'National' level access; with the User's (my Location) defaulted into the ComboBox and a list of all other Locations; Or, if I were hierarchy 'Region' a list of all the Locations in my region.

colRegionsCollection (before button push; count is 3) -

The colRegionsCollection (after button push; count is 817) -

[WarrenBelz]

@Anonymous ,

When you set varUser, the way set out for you all the fields in the record are captured, so varUser.Park is simply the Park field, however as you said this is working (please close this subject), so now concentrate on colRegions and your Combo Box.

You have now confirmed that it has records, so if you wanted to display the Park field in your Combo Box, the Items would be

colRegion.Park

Lastly, you need to filter colRegions (I am struggling to keep up with all the versions here) with the data you need. It was obviously correct to start with (and the code supplied filtered it), so I am not sure what you ran to make it the whole list. 

Can you please keep your responses short and to the point and give an opinion on what you might think is wrong.

We are now 18 posts into a simple drop-down list (and I am the third person to respond) and really need to close this.

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.

[Anonymous]

Thank you for all your help.

I'll figure out somehow.

You've been great.

Good day.