Answered

Changing Dropdown values from Sample to Custom Values

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

SJ-15052312-0 418 on at

Like (0)

Report
Copy link

Link copied!
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".

Was this reply helpful? Yes No
PowerAid on at

Like (2)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Verified answer

SJ-15052312-0 418 on at

Like (1)

Report
Copy link

Link copied!

Your solution is better if you don't plan to use that collection anywhere else. Mine wastes more space.

Was this reply helpful? Yes No