Add 'Other" to Dropdown list based on SharePoint column

(0) Share

Report

Posted on by nemanjasovic011

240

Hello,

I have what seems to be a simple request. My 'items' formula for dropdown is coming from SP data source and it is

Distinct(AutoData,ParentCode)

- which works fine(to get values from 'ParentCode' SP column). User needs to be able to select 'Other' at the bottom and I am struggling to add this option to the formula above. Updating SP list is not an option as list is dynamic and then I have to worry about sorting so that 'other' appears at the end of all options.

Thank you for your help.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nemanjasovic011

Do a collection for the Items

ClearCollect( colDD, Distinct( Autodata, ParentCode ), {Result: "Other"}, )

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.

Visit my blog Practical Power Apps
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@nemanjasovic011

Please consider changing your Formula to the following:

Ungroup( Table({Items: Distinct(AutoData,ParentCode)}, {Items: Table({Result: "Other"}) } ), "Items" )

This will provide you with a more dynamically changing dropdown based on your AutoData source.

I hope this is helpful for you.
nemanjasovic011 240 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked exactly as I intended. Thank you both.