cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Populate dropdown from sharepoint

Hello,

 

I can't find how to populate a dropdown list from SP. In my SP list named tblAff i have two fields one called affNum and the otherone called affStatus. Values for affStatus are "Yes" or "No". I want to create a dropdown list in my power app containing all affnum data having affStatus = "Yes".

I have tried : Filter(tblAff;"Yes" in Lower("affStatus")) but i get anempty dropdown

 

Thanks 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Anonymous, 

Do you want to filter on affnum data that has a "Yes" affStatus?

Could you please tell me that if the affStatus is a Choice or Text type in your SP list?

1). If affStatus is a Choice type, please set the Items as below:

Filter(YourSPList,affStatus.Value="Yes").affNum

2). If affStatus is a Text type, please set the Items as below:

Filter(YourSPList,affStatus="Yes").affNum​

Hope it could help you at some degree.

Best Regards,
Qi

View solution in original post

4 REPLIES 4
StalinPonnusamy
Super User
Super User

Hi @Anonymous 

 

  • Items property to

 

Filter(tblAff,affStatus)

 

  •  Set value to the field/Column to display

Example

StalinPonnusamy_0-1630433040822.png

 

v-qiaqi-msft
Community Support
Community Support

Hi @Anonymous, 

Do you want to filter on affnum data that has a "Yes" affStatus?

Could you please tell me that if the affStatus is a Choice or Text type in your SP list?

1). If affStatus is a Choice type, please set the Items as below:

Filter(YourSPList,affStatus.Value="Yes").affNum

2). If affStatus is a Text type, please set the Items as below:

Filter(YourSPList,affStatus="Yes").affNum​

Hope it could help you at some degree.

Best Regards,
Qi
StalinPonnusamy
Super User
Super User

Agree. I assume affStatus is boolean since it has Yes and No

 

Filter(tblAff,affStatus).affnum

 

 

If this is a choice type then

 

Filter(tblAff,affStatus.Value="Yes").affnum

 

 

Note:

Filter(SPList, condition).FieldName or Set the field in the fields list on the properties panel. Both are the same.

 

Anonymous
Not applicable

Thank you the solution for Choice type works perfectly !

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,061)