
Announcements
I have two SPO lists.
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.
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 |