cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bgough
Level: Powered On

Choice Fields not showing as an option

I have a Sharepoint list with several fields, one of which is a Choice DataType.

When creating a new App from Scratch, I createed a Datasource pulling from that list.  The Choice field is not showiong up as an available field for me to add to the vertical list gallery.

What is the trick to making this field available for use?

Ultimately, I would like to use this field in a form as a GroupBy option.

 

Any guidance is appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Choice Fields not showing as an option

Hi @bgough,

 

Looks like it is a bug. I have created the forms from SharePoint list itself. Please report this to the ideas forum,

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



9 REPLIES 9
Super User
Super User

Re: Choice Fields not showing as an option

Hi @bgough,

 

I created a SharePoint list with choice data type. Set the datasource as this SharePoint list. I can see the choice field option sets when I run the PowerApp. Try to set the following:

 

Select the choice field from the user interface. Right hand side properties First set the Edit Lookup. Then set  Value1 as Value and Value 2 as Id.

 

a1.png

 

 

a2.png

 

 

a3.png

 

 

Thanks

  



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



EdRHedgehog
Level: Powered On

Re: Choice Fields not showing as an option

This is where I get

 

WebAuthoring abnormal termination.
Client date/time: 2016-11-15T03:46:43.556Z
Version: 2.0.542
Session ID: d8d1345c-0434-9b79-bfd6-652dbfe63d53
errorMessage: Script error.

bgough
Level: Powered On

Re: Choice Fields not showing as an option

listfields.png

Thank you for the reply @abm, but I do not even get to the point where I can adjust properties.  Smiley Happy

 

 

here is the list of fields in my SharePoint list

 

 

 

 

 

 

 

 

 

PAFields.pngAnd here is what I see after adding the list as a data source, and adding a 'Vertical' Text gallery.

As you can see, "Client Status" is not shown as an available field to display.

 

I have tried other Gallery options an d get similar results.

 

If i let PowerApps create all the forms for me automatically by choosing my list as the starting point, it creates it fine, and I am able to adjust the properties so the choice fields display correctly.  But if I try anything from scratch, I run in to this issue.

Super User
Super User

Re: Choice Fields not showing as an option

Hi @bgough,

 

Looks like it is a bug. I have created the forms from SharePoint list itself. Please report this to the ideas forum,

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Microsoft Employee

Re: Choice Fields not showing as an option

did this ever get solved?

Meneghino
Level 10

Re: Choice Fields not showing as an option

Hi @chmills

I think choice fields are not an issue in custom apps.  I personally always create app from a blank one and don't use forms/datacards as they are more trouble than they are worth.

Please see this for the ability to patch to choice columns:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Solved-patching-to-SharePoint-choice-and-lookup-...

Dirk
Level: Powered On

Re: Choice Fields not showing as an option

I got this solved by using the Destinct-function

Distinct(ListName.ChoiceColumn;ChoiceColumn.Value)

This adds the List Items to the items-property of a dropdown field.

It is also working in the WebStudio.

DamianJauregui
Level: Powered On

Re: Choice Fields not showing as an option

Just as an update on this, the following now appears to work on Galleries (I don't have this issue on Data tables), but ONLY if there's a single selection made, multiple select fields don't appear to work still;

 

  1. Insert a new Label you want to hold the value
  2. Go to the Advanced properties of the new label
  3. In the data section of the properties panel, add "ThisItem.Choicefield.Value" in the Text field, obviously replacing "Choicefield" with the name of the field in your SharePoint list.

That solved it for me. Hope it helps...

 

Highlighted
SergiP
Level: Powered On

Re: Choice Fields not showing as an option

I have the same problem from time to time, and what is worse is that is completely ramdomly...

so finally the best solution I found is simply ClearCollect the Choices in a collection and then use this collection instead of the function in the Dropdown.Items

 

I assume you have a Sharepoint List called  MyList, and that this list has a column called MyChoiceField (type Choice)

So in any screen.OnvVisible (or App.OnStart) you add:

ClearCollect(ChoiceCol_1, Choices(MyList.MyChoiceField))

then whenever you need a Dropdown with these field you can simply put as Items:    ChoiceCol_1

and it will work. 

I suppose there's a kind of delay problem that leaves the items empty... this way since you collect it into a local collection forehand you overcome the issue... (but this is purely my assumption Smiley Happy )

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 377 members 4,256 guests
Please welcome our newest community members: