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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report

Hey. Can I check the logic please?:

!IsBlank(selectedVendor) = selectedVendor is not blank

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

Was this reply helpful? Yes No
Verified answer

MM-07112006-0 49 on at

Like (1)

Report

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)

Was this reply helpful? Yes No