Forum Discussion
mleijzer
Oct 08, 2021Copper Contributor
Use dataverse as a source for lookop in Sharepoint Online list
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 Replies
- mleijzerCopper Contributor167 views, 0 replies. I think we can conclude that this is just not possible.
- trillian74Copper ContributorI'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?