Forum Discussion

ChrisO's avatar
ChrisO
Advocate I
10 years ago
Solved

Problem with LOOKUPVALUE not returning all values

Hello,   I have a datamodell from Dynamics CRM. I need to filter for example quotes based on dates and customer. My active relation is between quote and a datetable. No I want to add a custom co...
  • sdjensen's avatar
    sdjensen
    10 years ago

    ChrisO - Do you have a relationship from Angebot[Kunde ID] and Kunde[ID]? Did you make any transformation to any of the 2 columns since loading them from your source - change type etc. ?

jasiluka's avatar
jasiluka
Regular Visitor
5 years ago

I have the same issue.

In my accounts table i have a ownerid value of:

7ddf36e9-d03d-ea11-a812-000d3a86ad99

 

however when looking at Owner column which has a lookupvalue function, both blanks and correct value are returned for different lines.

Also expanding ownerid filter pane i see (surpirse) two identical values... 

 

 

 

how is that even possible...

I tried appying TRIM function for ownerid to get rid of any space however with no luck..