Use dataverse as a source for lookop in Sharepoint Online list

[mleijzer]

I have a few Sharepoint sites running. They all have listst that need employee info (lookup field). So now I have for every Sharepoint site a seperate list of employees. Every update has to be done over all the seperate employee listst.

I recently synchronised the employee data from our SQL server ERP system to Dataverse.

So I have one online source (table) where all employee data is stored.

Can this be used in lookup fields in Sharepoint Online lists? This way I always have one source of data which is automatically updated.

Tried to google it but I only find results explaining the other way around, fromSharepoint to Dataverse.

Thanks in advance!

[#2]

167 views, 0 replies. I think we can conclude that this is just not possible.

[#3]

I've kinda asked about the same scenario, but i need to access a dataverse api from my webpart. The only thing is that it seems to be little documentation around this.

It is possible - i'm only struggling making it work. Have you had any success or was this only a how to configure it question or were you about to solve it using code?