cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Choice sharepoint field - change to radio

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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Choice sharepoint field - change to radio

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.

9163.PNG

 

2)in powerapps, refresh the connection.

(since you change the field's setting)

9164.PNG

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:
9165.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Community Support
Community Support

Re: Choice sharepoint field - change to radio

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,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
Highlighted
Super User III
Super User III

Re: Choice sharepoint field - change to radio

@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.

Highlighted
Community Support
Community Support

Re: Choice sharepoint field - change to radio

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

9151.PNG

 

3)set the radio's Default:

ThisItem.fieldname.Value

 //please replace with your choice fieldname

9152.PNG

 

4)set this datacard's Update:

{Value:Radioname.Selected.Value}

//please replace with the radio's name

9153.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Prodigy
Post Prodigy

Re: Choice sharepoint field - change to radio

@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.

Highlighted
Super User III
Super User III

Re: Choice sharepoint field - change to radio

@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.

Highlighted
Community Support
Community Support

Re: Choice sharepoint field - change to radio

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.

9163.PNG

 

2)in powerapps, refresh the connection.

(since you change the field's setting)

9164.PNG

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:
9165.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Choice sharepoint field - change to radio

@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:

 

Elitezone_0-1600242987757.png

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:

 

Elitezone_1-1600243265238.png

 

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

 

Highlighted
Community Support
Community Support

Re: Choice sharepoint field - change to radio

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Prodigy
Post Prodigy

Re: Choice sharepoint field - change to radio

@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...

Highlighted
Community Support
Community Support

Re: Choice sharepoint field - change to radio

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,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,933)