web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Limit options in combo...

Power Apps

Unanswered

Limit options in combo box to active items.

(0) Share

Report

Report

Posted on by CG-25072327-0

9

I have two SPO lists.

"Programs". This list has "Program Name" and "Item Status" columns. "Item Status" is either "Active" or "Inactive"
"Invoices". This list has columns for typical invoice data. It also contains a look-up column for "Program Name" from the "Programs" list.

I am customizing the form using Power Apps. My goal is when users create new invoices, they will use the combo box control to choose from a list of only "Active" program names.

The default function for the combo box is:

Choices([@'Programs'].Program_x0020_Name)

I might be able to use the Filter function but I can't figure out how to write it.

Any suggestions? Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @geissler

You can try replacing it with

Filter(Programs,'Item Status' = "Active")

Just in case Program Name is not display, follow this after clicking your combo box.

✔️
Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future.

🔗
🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace

Was this reply helpful? Yes No

Join the conversation