Forum Discussion

PBGIT's avatar
PBGIT
New Member
6 years ago

Getting ID Number instead of Data when pulling a Lookup Column

Hey all,    I'm working on a dashboard which will show our employee's education levels. (Ex. Employee A has a masters from X School from X Year).    I'm pulling my data from a SharePoint online l...
Need Help
Tips and Tricks
Tutorial Requests
MFelix's avatar
MFelix
Super User
6 years ago

Hi PBGIT ,

 

Are you getting the user information from what table in sharepoint? You need to pick up the UserInfo table from sharepoint that has the full details of the users and then connected it to your list.

PBGIT's avatar
PBGIT
New Member
6 years ago

Thanks for the response. 

 

I do have the employee names on a seperate list (the one I use the lookup column for) and I have connected that as well to my dashboard. My issue now is connecting those lookup IDs to the names on the list, which I'm having trouble figuring out.

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Are you using a related table or a lookupvalue column?

    • PBGIT's avatar
      PBGIT
      New Member
      6 years ago

      Lookup value column. 

       

      I am using that column to create a relationship between two different tables.

      • MFelix's avatar
        MFelix
        Super User
        6 years ago

        Hi PBGIT ,

         

        If you have a relationship between both table you should not need to create any lookup table.

         

        I assume you have both tables connected by the ID so you just need to pull the name column from the oneside to the visualizations you need.

         

        Can you share a mockup file to check?