web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter radio button on...

Power Apps

Answered

Filter radio button on two SP columns?

(0) Share

Report

Report

Posted on by DGWolfe

Hi,

I have a radio button input connected to a SP list.

The first column is Department Names, the second is "In Scope" or "Out of Scope"

It should seem simple, but for the life of me, I can't remember how to narrow the results to "in scope" departments only.

Currently I have:

Choices(SP List.Department)

Which is fine for all departments, but any help how to now add a further parameter?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Tolu_Victor 197 Super User 2024 Season 1 on at

Like (0)

Report
Hi A simple filter function would solve your issue.

Now I'm not sure exactly how your table is configured but I assume the below should work
Filter(SPList, Scope = "In Scope").DepartmentName

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @DGWolfe,

Could you please tell me that if your Radio button displays all the departments?

Do you want to filter Radio buttons to display departments with in scope status?

Please write the following formula to filter the departmens:

ForAll(Filter(list,Scope="In Scope").Department,Department)

Was this reply helpful? Yes No
DGWolfe on at

Like (0)

Report

Thanks @v-qiaqi-msft this is exactly what I was after 🙂

Was this reply helpful? Yes No

Join the conversation