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

why is the dropdown choice not pickup from datasource?

Hi

 

I like to find out is the syntax not right?  data is not displaying from data source?

Thank you

 

it's a dropdown in SP with choice.

Thisitem.Category

 

bbsin_0-1632385107499.png

 

6 REPLIES 6
C-Papa
Super User
Super User

Hi, Thisitem.Category or Thisitem.Category.Value is how you return the value in the column, but you want to return the choices, for this use the below formula in the items property

 

Choices([@YourDataSourceName].Category

 

where YourDataSourceName is you SharePoint List name

bbsin
Post Prodigy
Post Prodigy

hi @C-Papa 

 

Yes the item is 

Choices([@YourDataSourceName].Category

 

I want to return back the data to display 

I use 

bbsin_0-1632386811743.png

 

Nothing is display when I put

bbsin_1-1632386841210.png

 

 

StalinPonnusamy
Super User
Super User

Hi @bbsin 

 

Looks like you are trying to display in the dropdown.

So Items property of dropdown to

Choices([@YourDataSourceName].Category)

And set Default property to

ThisItem.Category.Value

 

Example

StalinPonnusamy_0-1632408743407.png

 

 

bbsin
Post Prodigy
Post Prodigy

Hi 

 

Ok it pick up but why is it default pick the category on new items that I have not select any choices yet?

I use dropdown box not combo

 

bbsin_0-1632816924268.png

StalinPonnusamy
Super User
Super User

Hi @bbsin 

 

This should be blank when you use the form then set NewForm(EditForm1). We may have different behavior if the control is in other places.

 

Let me know where the control is placed. Is it inside the form or Gallery or on the screen?

StalinPonnusamy
Super User
Super User

Hi @bbsin 

 

Please let us know if anything needs on your post. We can help with this.


Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,164)