Answered

Text label referencing a Dropdown is displaying text, but !isblank is returning value as True?

(0) Share

Report

Posted on by MM-07112006-0

Hi everyone,

I'm a little confused at what is going on here. I have a text label that is returning the value that is selected from my dropdown box and it is correctly displaying the text. But when I try to pull a reference field that is based on an Excel table, the result is always blank. So I tried a debugging label and for some reason the !IsBlank() function is returning as "True" even when an item is selected, so I think this is the root cause of why I'm not getting any referenced values from the table. Any idea what is going on?

Categories:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (1)

Verified answer

MM-07112006-0 49 on at

Like (1)

Report

Text label referencing a Dropdown is displaying text, but !isblank is returning value as True?

So my VENDORID excel file has a bunch of "spaces" trailing and for whatever reason, PowerApps would automatically trim the ends in the Lookup function but still try to reference the field with trailing spaces. The following formula worked for me:

LookUp(APVEN, VENDNAME = TrimEnds(VendorList.Selected.VENDNAME), VENDORID)
Suggested answer

KeithAtherton 3,649 on at

Like (0)

Report

Text label referencing a Dropdown is displaying text, but !isblank is returning value as True?

Hey. Can I check the logic please?:

!IsBlank(selectedVendor) = selectedVendor is not blank

If selectedVendor has been set, then this logic is correct?