Choice sharepoint field - change to radio

[Elitezone]

Hello,

In my PowerApp I use choice field from Sharepoint List. This list however always drop-down menu. I would like to change it to radio list, but it seem impossible for me. When I change properties of this field in sharepoint it changes nothing in PowerApp.

I tried to add this field again, but no change is made. It is always the same.

Are there any ways to make it possible?

[WarrenBelz]

@Elitezone ,

Do the following

• Unlock the card (in Advanced tab at right)
• Take a note of the name and Items property of the drop-down
• Delete the drop-down
• Add a radio control and give it the same name.
• Make the Items of the radio control the same as the drop-down and it all should work.

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.

[v-yutliu-msft]

Hi @Elitezone ,

Do you want to change to use radio instead of drop down for choice field in form?

I agree with the steps that @WarrenBelz  provided.

However, you not only need to set the radio's Default, but also need to set the radio's Default and the datacard's Update.

Could you tell me whether your choice field allows multiple choice? I assume that no.

I made a similar test that you could refer to:
1)Unlock that datacard, delete the original drop down, insert radio into that datacard

2)set the radio's Items:

Choices(listname.fieldname)

//please replace with your listname and your choice fieldname

3)set the radio's Default:

ThisItem.fieldname.Value

 //please replace with your choice fieldname

4)set this datacard's Update:

{Value:Radioname.Selected.Value}

//please replace with the radio's name

Best regards,

[Elitezone]

@v-yutliu-msft @WarrenBelz 

You guys are great, but this is a bit too much for me.

I don't know how to pick a radio in my Power Apps, when I add data form it is by default a drop down...

Also after investigating my company needs I came to conclusion that both radio and drop-down won't work. I need a multi-select list.

What would be the easiest task to do to make my list multi not a single choice?

As far as I understand I have to change property of the field in Sharepoint admin panel of list, but what next? How to make this field visible in a multi-choice?

Thank you, and sorry for my ignorance.

Edit.

I change my list setting - SelectMultiple - to true. Now the list can select more than one option, but:

1) When I save it with Sharepoint List field set on drop-down list - only one choice is saved

2) When i change property of Sharepoint list field field of choice (allow more than one choice) the form is not saved with error in runtime enviroment - requested operation is invalid. Item could not be created check if input is valid.

[WarrenBelz]

@Elitezone ,

The easiest way is to change your Choice field in SharePoint to allow multiple values, delete the control and re-add it. It will come in as a Combo box and should do what you need.

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.

[v-yutliu-msft · Accepted solution]

Hi @Elitezone ,

Do you want to change single choice to multiple choice?
If so, I suggest you use combo box instead of drop down or radio.

Drop down or radio only allows single choice.

Please follow the steps:
1)in sharepoint , change this field's setting from single choice to multiple choice.

2)in powerapps, refresh the connection.

(since you change the field's setting)

3)delete your original form

insert a new form, set its data source to your sharepoint list

(since you change the list's setting, so you need to create form)

Then the single choice column in the form will display as multiple choice automatically.

Just like this:

Best regards,

[Elitezone]

@WarrenBelz @v-yutliu-msft 

Ok - on my sharepoint panel admin it looks a bit different.

I do not have a setting allow multiple selections like you. Instead I have 3 choices in type:

Translate:

dropdown

radio

field of choices (allows for mutliple selections)

So I used third setting.

My form look pretty OK now. I have only problem with DataTable.

When I changed this field it now destroyed data table section:

Error: Expected value text, but this rule is generating Table values - Category.Text

[v-yutliu-msft]

Hi @Elitezone ,

Do you want to display multiple choice column in data table?

The reason why you met this problem is that:
multiple choice column is actually a nested table.

If you want it to display correctly, I suggest you add a column with text value by using Concat function for this multiple choice column.

Try to set the data table's Items:

AddColumns(list,"choicevalue",Concat(choicecolumnname,Value&","))

Then select choicevalue column to display in this data table.

Best regards,

[Elitezone]

@v-yutliu-msft 

My data table already has a function in Items:

Sort(Search(IdeaBox_1;SearchBox.Text;"Nazwa";"Opis");Utworzony;If(SortDescending2;Descending;Ascending))

When I add your function after this with ;; and different delimeter I receive a tons of error:

AddColumns(IdeaBox_1;"Kategoria";Concat(DataCardValue3.Selected.Value;Value&";"))

Whole function looks like that:

Sort(Search(IdeaBox_1;SearchBox.Text;"Nazwa";"Opis");Utworzony;If(SortDescending2;Descending;Ascending));; AddColumns(IdeaBox_1;"Kategoria";Concat(DataCardValue3.Selected.Value;Value&";"))

Something is wrong.

DataCardValue3 is my multi category field that I use...

[v-yutliu-msft · Accepted solution]

Hi @Elitezone ,

You need to combine these two formulas together, but to just connect them with ";;".

Try to set the data table's Items like this:

Sort(
     Search(
            AddColumns(IdeaBox_1;"Kategoria";Concat(category;Value&";"));
            SearchBox.Text;"Nazwa";"Opis"
           );
     Utworzony;If(SortDescending2;Descending;Ascending)
)

Best regards,