Forum Discussion
LOOKUPVALUE Randomly Returns Blank Values
darshp1 and you sure there are always values for the volunteers name in volunteers, ie you dont have duplicates, and one is blank and the other isn't. Also does it always do it for the same id's or is it random, so an id that worked today wont work tommorrow, is there consistency in the id's that throw up blanks?
vanessafvg I checked and rechecked the Volunteer IDs and they are all distinct values. Now some of the names are the same but that shouldn't matter.
It's the same ones happening over and over again. Even tried it on a different computer to see if there was a cache issue but same exact results.
It must be something in the data.
Can you share it? in a DM perhaps?
I had the same issue, can you please advise how to fix the error, many thanks
darshp1have you tried to create a relationship between the two tables between the fields instead of a lookup.
- I having a very similar issue.
50% of values return the lookup value correctly the others are blanks.
I’ve checked the record returning blanks and the search column and lookup column are absolutely fine and matching. Same data type and I even went to the step of trimming left and right in both fields to ensure the lookups value was found.
Why some are working and others are not it has me beat.
An updates on this one ?shaunwilks can you share your pbix?
Unfortunately I cannot as it contains sentive data.
I will rebuild the model from the start and see how I go.
There is a join to the label I am using in the lookup so wonder if that is impacting
