cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brucemZA
Helper I
Helper I

Adding a single specific dropdown option to a table-column-based dropdown

Hi all - so I know I can achieve this by adding '<Please Select>' as an item to my table, but I'm trying to improve my Power Apps and it seems like an interesting problem to solve in a better way.

 

So let's say I have a table with: (i.e. with repeats of an item that need to be filtered with Distinct or similar)

Apple

Apple

Apple

Banana

Banana

Carrot

 

Without adding <Please Select> to my table, (which is a bit a hack because it doesn't belong in the table) how can I get a dropdown in my PowerApp with:

<Please Select>
Apple

Banana

Carrot

 

I tried Concatenate, but it expects a Table Column in and a dropdown works a bit different as it doesn't take a Table Column

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @brucemZA ,

Do you want to make the drop down display '<Please Select>'  by default?

Here are two solutions:

1)use combo box

(drop down does not have InputTextPlaceholder property)

set the combo box's InputTextPlaceholder:

 

"Please Select"

 

Then the combo box will display '<Please Select>'  by default.

Actually, the  '<Please Select>' does not be added into combo box's items. Because combo box's default selected items could be blank.

2)use drop down

Since drop down's default selected item could not be blank, so to make it display '<Please Select>'  by default, you need to add the item '<Please Select>' in its Items.

For example: I set the drop down's Items:

 

Distinct(
         Filter(
               Split(
                     Concatenate(
                                  Concat(deeplink,Title&","),
                                     // connect all the items of the original table
                                  "Please Select"&","
                                    //connect with "Please Select"
                                 ),","
                                   //split to a table
                       ),!IsBlank(Result)
                  ),
            Result
           )

 

Then  '<Please Select>'  will be added to the drop down items.

Set the drop down's Default:

 

"Please Select"

 

Then drop down will display   '<Please Select>' .

85.PNG

 

 

You could choose the solution based on your demands.

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
eka24
Super User
Super User

I think you can use the InputTextPlaceholder property. Set it to "Please Select"

 

Also change the AllowEmptySelection to true.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Oh wow. Sometimes I forget to think of the simplest possibility. That sounds perfect! I’ll test tomorrow and confirm your answer here tomorrow 😀

That's fine

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

v-yutliu-msft
Community Support
Community Support

Hi @brucemZA ,

Do you want to make the drop down display '<Please Select>'  by default?

Here are two solutions:

1)use combo box

(drop down does not have InputTextPlaceholder property)

set the combo box's InputTextPlaceholder:

 

"Please Select"

 

Then the combo box will display '<Please Select>'  by default.

Actually, the  '<Please Select>' does not be added into combo box's items. Because combo box's default selected items could be blank.

2)use drop down

Since drop down's default selected item could not be blank, so to make it display '<Please Select>'  by default, you need to add the item '<Please Select>' in its Items.

For example: I set the drop down's Items:

 

Distinct(
         Filter(
               Split(
                     Concatenate(
                                  Concat(deeplink,Title&","),
                                     // connect all the items of the original table
                                  "Please Select"&","
                                    //connect with "Please Select"
                                 ),","
                                   //split to a table
                       ),!IsBlank(Result)
                  ),
            Result
           )

 

Then  '<Please Select>'  will be added to the drop down items.

Set the drop down's Default:

 

"Please Select"

 

Then drop down will display   '<Please Select>' .

85.PNG

 

 

You could choose the solution based on your demands.

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@eka24 There is no InputTextPlaceHolder propery for a dropdown....

@v-yutliu-msft wow, this solution bent my brain a bit, working through all the layers of that formula, but it's all working great now 🙂

I thought you were referring to a combobox

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,909)