Convert String Column to show up Email address

[RamyHussein]

Dear Collogues
My KNIME flow connected to SharePoint List as Data source,
in this SharePoint List , there are a column called “Action Responsible email”,
after applied SharePoint online List Reader" it shows as Numbers?
what should i do to convert it to emails using KNIME?

[laaaarsi]

Hey @RamyHussein

I would assume that this is column of type Group or Person, right? The underlying library which we are using only returns a lookup id which we can’t resolve to a name, e-mail, etc. unfortunately. This is some limitation of the Microsoft API. I quickly did some research and found out that the information is stored in the User Information list (a system list) you could try and check if you have access to this list and join your results with this list. You can join on the ID field of this list with the column of your own list, but I guess you need to have admin rights to see this list.

You need to check the “Show system lists” option in the reader.

Best regards
Lars

[RamyHussein]

Hi @laaaarsi ,
this is what i got once i run the flow. can i do something in configuration?

[laaaarsi]

You need to read in another list, the one I mentioned in my previous post and join it with your data.

[RamyHussein]

Hi @laaaarsi thanks for your help.
I did read the other list of emails, and i think i have to transform data & Merge.
I will let you know once finish