Limit options in combo box to active items.

(0) Share

Report

Posted on by CG-25072327-0

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 (1)

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