Answered

Share point Choice Data type column value not getting populated to Power apps drop down

(0) Share

Report

Posted on by Community Power Pla...

Hi Team,

I have a SharePoint list with several fields, one of which is a Choice DataType. I created a Data source pulling from that list. The Choice field is not populating as an available field for me to add to the drop down list in power apps. What is the trick to making this field available for use?

Thank you

soma

Categories:

Building Power Apps

Issue with Choice...

I have the same question (0)

All responses (8)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Is the formula on the Items property of the Gallery?

Distinct (Choices (Datasource.ColumnName), ColumnName)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Items property of the drop down list

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Distinct (Choices (Datasource.ColumnName), ColumnName)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have tried the same , still no value populated in drop-down ..

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I don't know what trick i am missing , still i am not able to populate those data.

choice type _Issu...

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

kindly look at the formula i gave. it did not include THISITEM.
Distinct(Choices('Issue Notifications'.'Feedback on Issue'),Result)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have tried the same , still no data. Please see the attached file

my drop down control is inside Gallery 1. I have attached the issue

Distinct (Choices ('Issue Notifications'.'Feedback on Issue'),Dropdown2 )
Distinct (Choices ('Issue Notifications'.'Feedback on Issue'),ThisRecord )
Distinct('Issue Notifications', 'Feedback on Issue').Result

IsueWithChoiceTyp...

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (0)

Report
Hi @Anonymous ,

The Choices() function can provide a list of available choices, and there is no need to Distinct function if all choices are unique.

In addition, I suggest you use Combobox, instead of Dropdown, and then set the Items property of Combobox as follows.

Choices('Issue Notifications'.'Feedback on Issue')

PS. the correct Distinct syntax is Distinct(Choices('Issue Notifications'.'Feedback on Issue'),Value)

Hope this helps.
Sik

Was this reply helpful? Yes No