Sharepoint List Choices Column

(0) Share

Report

Posted on by psreek

323

Hi,

We have a Sharepoint List that has multiple columns of type Choice. For each of the columns, we have set "Can add values manually".

Now, when using a SharePoint Form to enter data, we get the following option to "Specify you own value"

Instead of the SharePoint Form, we wanted to use the integrated Power Apps Form functionality. By default, the Power Apps Form creates combobox for Choice type columns. We changed this to RadioBoxes. But, we are unable to get the "Specify your own value" option along with the box to "Enter value here".

The formula for the "Items" is - Choices([@'Gift Registry PowerAppForm'].'2.Declarations'). This returns a table without the option for "Specify your own value".

Is there any way to update the above formula to append another row. Also, how can we create a textbox to allow user to specify their own value.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I don't think you can get the option for "Specify your own value" by default. You can maybe store the choices in a collection and manually add another row called "Specify your own value". And when the user selects that option display a text field. In order to add a new choice, you need to use PowerAutomate as far as I know (I'm sure someone explained the steps to add a new choice)

Was this reply helpful? Yes No
psreek 323 on at

Like
a
(1)

Report
Copy link

Link copied!

@Akser

Thanks. I was able to get this to work using the below formula -

Ungroup(Table({MyTables:Choices([@'Gift Registry PowerAppForm'].'2.Declarations')},{MyTables:Table({Value:"Specify your own value:"})}),"MyTables")

Now I will have to work on a TextBox to enter the value.

Was this reply helpful? Yes No
psreek 323 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually, I have hit another roadblock. My assumption was that the original formal - Choices([@'Gift Registry PowerAppForm'].'2.Declarations') returns all the Choices specified in the Edit Setting of the column -
I was able to get the Text Box to write a different value to column - (refer the last item GR-05)

But, now when I try to create a New Record, the choices show are -
The value "Test for Other" is being returned by Choices([@'Gift Registry PowerAppForm'].'2.Declarations'). This doesn't seem to make sense as this is a new override value and not part of the config of the column.

Was this reply helpful? Yes No