Error when trying to join 2 SharePoint Lists in a gallery

[anon23u9412]

I am trying to include the CoE data (A multi-value LookUp column from another table) along with the relevant data taken from 'Employee_Skill - MySkills'. I will be using the CoE values to filter this data.

I understand that the way to join lists like this is to use AddColumns and Lookup however I'm getting the error:

'Incompatible types for comparison. These types can't be compared: Number, Table.'

Employee_Skill - MySkills

Skill is a LookUp value taken from 'Skills - MySkills' and User_ID is my email

Skills - MySkills 

Any help would be greatly appreciated !

[NandiniBhagya20]

Hi,

Can you please share the formula in which you are getting error.

[anon23u9412]

AddColumns(Filter('Employee_Skill - MySkills', Title=User().Email), "CoE", LookUp('Skills - MySkills', ID = 'Employee_Skill - MySkills'.'Skill: ID', CoE))

[NandiniBhagya20 · Accepted solution]

On button Onselect, i tried below formula and it worked for me - 

Clear(colTP1);Clear(colTP2); Collect(colTP1, AddColumns(EmployeeSkills, "IDNew", ID)); Collect(colTP2, AddColumns(colTP1, "ColumnNewName", LookUp(SkillsList, Title = LookUp(EmployeeSkills, ID=IDNew).Skill.Value, CoE)))
In above formula,

EmployeeSkills is 'Employee_Skill - MySkills'

and SkillsList is Skills - MySkills'

Now you can use colTP2 collect in your gallery and add a label to it

On Text property of label you can add below formula to check -

Concat(ThisItem.ColumnNewName.Value, Value, ",")