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?
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:
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?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.