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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,324)