Answered

Changing Dropdown values from Sample to Custom Values

Like (0) Share

Report

Posted on 16 Oct 2018 19:53:31 by PowerAid

My Powerapp is connected to a SharePoint List to store it's field data. One of the fields is Request Status and it is a Single Line of Text. I have it in my form and want to change it to a dropdown. I have unlocked the Datacard and deleted the single line of text datacard value and then added a dropdown control. I changed the Update Property to ddRequestStatusNew.Selected.Value which is the name of the new dropdown. The default values are 1, 2, and 3. I noticed that the Items property of the dropdown control is set to DropDownSample and obviously this would need to be changed.

I want to replace the DropDownSample with custom values like New, On-Hold, In-Progress, Closed. Can I add this in a formula in PowerApps or do I have to create a custom list in SharePoint and have it point to that list to receive the item choices? I know in infoPath, you could set these values in the dropdown control or you could have the values come from a SP list). For something this simple, I was hoping that the option for managing it in the PowerApps dropdown control would be easier.

Categories:

General Questions

All responses (3)

Answers (1)

Verified answer

SJ-15052312-0 417 on 16 Oct 2018 at 20:46:34

Like (1)

Report

Re: Changing Dropdown values from Sample to Custom Values

Your solution is better if you don't plan to use that collection anywhere else. Mine wastes more space.
PowerAid on 16 Oct 2018 at 20:45:04

Like (2)

Report
Re: Changing Dropdown values from Sample to Custom Values

@samuelJ wrote:
Not sure if there is a quicker way, but you can create a collection with your desired values and set that to be the items in the drop down.
Create a collection:
ClearCollect(myCollectionName, {Name:"on-hold"}, {Name:"passed"}, {Name:"Not-passed"});
Then set the items propery of your drop down to be "myCollectionName.Name".
I just figured out that you can type ["New","In-Progress","On-Hold","Closed"] in the Items property of the dropdown control. I wonder what the pros and cons are of the two options.
SJ-15052312-0 417 on 16 Oct 2018 at 20:26:21

Like (0)

Report
Re: Changing Dropdown values from Sample to Custom Values

Not sure if there is a quicker way, but you can create a collection with your desired values and set that to be the items in the drop down.
Create a collection:
ClearCollect(myCollectionName, {Name:"on-hold"}, {Name:"passed"}, {Name:"Not-passed"});
Then set the items propery of your drop down to be "myCollectionName.Name".