When combobox is empty set lookup labels to empty

(0) Share

Report

Posted on by Dorinda

1,512 Microsoft Employee

I have a screen that has a Combobox that looks up different people in AD

When nothing is selected I do not want anything showing up in the three labels below the combobox which are lookups

Upper(LookUp(mapPins,cmb_Employee.Selected.DisplayName='Current Occupant'.DisplayName).Building)

How can I clear out that information if the Combobox is empty?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Dorinda

It's already going to be blank! If there is nothing selected in the combobox, then the Lookup is going to return nothing...and thus the label will be blank.

Are you seeing something different?

Was this reply helpful? Yes No
Dorinda 1,512 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes but as you can see there is data in those labels in orange so it is not clearing.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Dorinda

I see that there is something there...but there should not be! Scrutinize your formula by placing your cursor at various points in it to determine where it is getting a value.

First, switch your formula to be more correct to:

Upper(LookUp(mapPins,'Current Occupant'.DisplayName = cmb_Employee.Selected.DisplayName, Building)

Then, for example, highlight the part in red below in your formula editor...the editor should tell you that it is blank if there is in fact nothing selected.

Upper(LookUp(mapPins,'Current Occupant'.DisplayName = cmb_Employee.Selected.DisplayName, Building)

Was this reply helpful? Yes No
Dorinda 1,512 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I havent selected anything yet something is still being selected

Was this reply helpful? Yes No
Verified answer

Dorinda 1,512 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Ok I have it working now with a bit of a difference then what you sent @RandyHayes

If(supervisor,Upper(LookUp(mapPins,cmb_Employee.Selected.DisplayName='Current Occupant'.DisplayName).Building),Blank())

Created a variable onVisible of the screen

UpdateContext({ enabled: false, visible: false, supervisor: false })

Everything works as expected.

Was this reply helpful? Yes No