Forum Discussion
Helper IIHow do I split up a column and do a lookup to another table based on the values?
I'm having a hard time describing this because I'm new and don't know 'what' is the proper approach.
I have a table with a column that has data like this:
[{"ItemId":11171,"WebId":"797ed54e-00c1-4254-a32d-3fb291fc16d2","ListId":"e9bf0b5a-1630-4a7d-babd-aa829f16d79f"}]
This is a related item in a SharePoint list.
I need to do a lookup on ItemID to another table.
In this case I have a Documents folder and a Tasks List. The task has the related items table. The Documents contains the ItemID of the doc I want to lookup. I then just want to grab the title.
I'm not sure if I should be doing a custom column or something else. I have no clue how to go about doing a lookup. I see examples and none match up with where I am in PowerBI so I have no clue.
I found a handy button that parses the data.
I then expanded the new json column to get the data I wanted.
Then I used that column and merged queries to get the column.
3 Replies
- lbendlin
Super User
load all tables as is into Power BI. Join them in the data model. No need for lookups.
- ComputerHabit
I found a handy button that parses the data.
I then expanded the new json column to get the data I wanted.
Then I used that column and merged queries to get the column.Thank you lbendlin
Hi, ComputerHabit
You have solved your current problem. You can mark your reply as a solution so that other people in the community can quickly find a solution when they encounter similar problems.
If you encounter new problems during use, you can post again so that more community members can help you in time.
Your cooperation will promote the development of the community together with us. Thank you again.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
