Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Replacing concatenated values from related table

I have two tables that come in from Sharepoint online lists. One of the fields is a multi select lookup value (called "App") from the other table and when Power Query brings it in it brings it in as a list, which I then extract to comma delimeted values. The problem is that rether than bringing in the name of the app, it brings in the ID of the app's record. I ultimately end up with a concatenated list of app IDs rather than their names. How can I replace the app's IDs with their names? Example:

 

Table 1:

IdTitleAppsId
1Record 13, 5, 7
2Record 22, 4, 6

 

Table 2:

IdApp
1App1
2App2
3App3
4App4
5App5
6App6
7App7
8App8
9App9
10App10
11App11
12App12
13App13
14App14
15App15

 

Desired result for Table 1:

IdTitleApp
1Record 1App3, App5, App7
2Record 2App2, App4, App6