Populate dropdown from sharepoint

[Anonymous]

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 

[StalinPonnusamy]

Hi @Anonymous 

• Items property to

Filter(tblAff,affStatus)

•  Set value to the field/Column to display

Example

[v-qiaqi-msft · Accepted solution]

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.

[StalinPonnusamy]

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]

Thank you the solution for Choice type works perfectly !