undefinedPowerApps

[nmccool]

Trying to make a selection from Projects list, column 2 (Project), but column 10 (Active) has to be true.  Can this be done?

[phipps0218]

You can use the Filter () function to filter only projects that are active.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg

[nmccool]

I have tried, i need some assistance on how to write that

If(Filter(Projects,Project)(Projects,Active=true) ????  I have tried several different ways

[phipps0218]

Here is an example to filter the projects:

Filter(Project List, Active = "true")

[v-qiaqi-msft · Accepted solution]

HI @nmccool,

Do you want to filter the Project based on the Active column?

Could you please tell me if the Active column is a Yes/No column type and what is the column type of the Project?

If the Active column is a Yes/No column and the Project is a Text column in your list, please try to modify your formula as below:

Filter(Projects,Active=true).Project