Help Needed: Adding Custom Option to Dropdown in Power Apps

(1) Share

Report

Posted on by ursNani

215

Hello everyone,

I’m struggling to add an additional option to a dropdown in Power Apps using the With function. Here’s my scenario:

I have a list called REA Matrix.

I have a dropdown control in Power Apps that pulls data from the Title field of the REA Matrix list.

I want to add an additional option to the dropdown: “My region is not listed”.

Here’s the formula I’m using in the Items property of the dropdown:

With(
    {_items: Distinct('REA Matrix', Title)},
    Ungroup(
        Table(
            {Items: Table({Title: "My region is not listed"})},
            {Items: _items}
        ),
        Items
    )
)

However, this is giving me a value from the list and a record with the title “My region is not listed”.

Here is the results of the screen short

Can anyone help me figure out how to properly add this custom option to my dropdown? Any suggestions or corrections would be greatly appreciated!

Thank you in advance!

Categories:

Using Apps Using Formulas

General Questions

Screenshot 2024-0...

All responses (1)

Answers (1)

Verified answer

WarrenBelz 146,702 Most Valuable Professional on at

Like (0)

Report
Help Needed: Adding Custom Option to Dropdown in Power Apps

Hi ursNani

You should just need this
Table( {Value: "My region is not listed"} Distinct('REA Matrix', Title) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee