cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShowMeTheAnswer
Level: Powered On

Blank requirements in dropdown - surely it can't be this complicated!

Hi,

So, based on some answers before, I've set some dropdowns, both on a new/edit form, and a "searchy type on" to have the following for example:

"Items" property is set to:

Ungroup(Table({Item:Blank()},{Item:'[dbo].[MMMPRODUCT]'}),"Item")

Default can be set to anything (it has no affect), one idea is Blank().

 

What this gives me is, what I thought my client wanted:

a) Field appears "Blank" in the UI before the dropdown is selected.

b) The list of "Items" has a blank Value at the top.

I still think it's good for "editable" lists and remains the best option I've found.

But what I/he really wants is:
a) Field appears "Blank" in the UI before the dropdown is selected

BUT:
b) The list of items DOES NOT have a blank value at the top.

If you take out this bit:

 

{Item:Blank()}

Then I'm back to the original problem: SharePoint pointlessly assumes I want to select the FIRST value in the list, and that is what appears in the UI, before the user has selected anything!
e.g. a) Field DOES NOT appear Blank in the UI! It has a value in it! In my example, the first product in the list!

Why on earth would I want that - I can see no scenario ever where that would make sense!

 

Any ideas? It's not a dealbreaker for the App but it would be nice to provide a decent and sensible UI for our end users?

 

 

2 REPLIES 2
Dawidvh
Level 10

Re: Blank requirements in dropdown - surely it can't be this complicated!

Hi @ShowMeTheAnswer

Consider using a -SELECT- as the first item, and then update your validation to ensure that the value is not -SELECT- at the time of doing the patch or submit.

 

ShowMeTheAnswer
Level: Powered On

Re: Blank requirements in dropdown - surely it can't be this complicated!

Thank You - I did see that proposed online as a potential solution..

But I'm not convinced really - whether the first option is Blank or -SELECTION-  either way is not great.

And selection (as you mentioned) would require additional validation and to me is potentially more confusing.

=

I'm holding out for the possibility of a Blank default but no blank (or other item representing a blank in the list..

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,574)