Adding item 'Other' after prepopulating dropdown with SharePoint list as datasource

(1) Share

Report

Posted on by jQuery

Friends,

I added a dropdown field that gets its item(s) from a SharePoint list.
Now, I want to add the item 'Other' to this list.

Must be a dropdown list
Would prefer to have 'Other' added from the app rather than adding as an item in the SharePoint list.
'Other' is NOT being added to the list. It's used as an option/item in the dropdown - but will NEVER be added to the SharePoint list.
if user selects 'Other', no additional field is needed.

Many other forum replies use a combo box and/or they add the item 'Option' to the SharePoint list. I don't want either of these.

Can anyone help?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

To add an -Other- entry to the dropdown you can use the Table() function to build the entries for the dropdown. Assuming that the field displayed in the dropdown is the Item field the Items entry for the dropdown would look something like this

Table({Item: "- Other -"}, [what is normally in the Items property of the dropdown])

Using Table() you can prepend a record to the list being used to populate the dropdown. Then have the app respond accordingly if that is what is chosen.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jQuery,

Adding to @Pstork1's response and addressing the second part of your question. Example below assumes you are using a Choice or Lookup column for the Items of the drop-down - if not replace the second part of the code with your currect Items and if applicable Value with whatever field name you are displaying. So your Items
Table( {Value: "Other"}, Choices(SPListName.FieldName) )

However you also do not want Other to be added to the SharePoint List - the easiest way is to put this OnChange of the drop-down
If( Self.Selected.Value = "Other", Reset(Self) )

Please ✅ 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jQuery,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No