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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,652)