cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmccool
Helper III
Helper III

undefinedPowerApps

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

1 ACCEPTED SOLUTION

Accepted Solutions

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
Best Regards,
Qi

View solution in original post

4 REPLIES 4
phipps0218
Super User
Super User

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

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

Here is an example to filter the projects:


Filter(Project List, Active = "true")

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
Best Regards,
Qi

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