web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Need combobox to show ...

Power Apps

Unanswered

Need combobox to show record value not in Items property

(0) Share

Report

Report

Posted on by Ed_Bellman

62

So I have a combobox where the Items property is a list of active Sales Reps - e.g.

Filter(Employees, Dept=4 && Active=true)

- how can I display the record value if it isn't in the Items properties? Meaning, if the Sales Rep for an existing record is now Inactive, they won't be in the Items property list, but I still need them to show as the default value. However, they should not show in the dropdown if the user wants to select a new Sales Rep.

Does this make sense? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Ed_Bellman

You could have a toggle control next to the combobox to show active/all with TrueText: "Active" and

FalseText: "All". No need for the If(Active as it is already defined as true or false. The Items property of the combobox would be:

If( Toggle1.Value, Filter( Employees,Dept=4 && Active ), Employees )

Was this reply helpful? Yes No
Ed_Bellman 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah, that's not going to work in this scenario but thanks for the idea.

You wouldn't think this would be an issue, I mean even native SPO handles this with choice fields - if you change or remove a choice the previous values stay as-is until that record value is edited. The record value (DefaultSelected) should display regardless of the Items property.

Was this reply helpful? Yes No

Join the conversation