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.
This worked exactly as I intended. Thank you both.
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.
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