Convert Dropdown Text Item to number column in SP

(0) Share

Report

Posted on by barbossa_94

Hi everyone,

I have the following situation:

- SP List with number column (numcol1)

Form in PowerApps with a dropdown corresponding to numcol1. The user answers a question (Options NA,A,B,C,D) and clicks on the dropdown where he can select (NA,A,B,C,D). I placed this as followed into the item property of the dropdown:

ITEMS:["NA;"A";"B";"C";"D"]

Instead of the text presented to the user I want to store numbers in the SP list based on the answers so,

NA in dropdown to no entry in numcol1

A in dropdown to 0 in numcol1

B in dropdown to 1 in numcol1

....

If i open the form at a later point through a gallery it is also important that the text options are displayed in correspondence to the stored number, so the user can change his answer.

Does anyone have an idea how to realize this?

Working on it for ages now and I can't find the solution, but I fell like it must be fairly simple.

Help is much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
@barbossa_94

1. In your App.OnStart property use this code to create a collection:

ClearCollect(colTextValues,Table({Text:"NA",Value:Blank()},{Text:"A",Value:1}))
You have to add the records for B,C,D...

2. Change the Items property of your DropDown to
colTextValues
3. Change the Default property of your DropDown to
LookUp(colTextValues,Value = ThisItem.numberCol).Text

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.

Was this reply helpful? Yes No
barbossa_94 51 on at

Like (0)

Report

@PowerRanger legend. worked like a charm.

Was this reply helpful? Yes No