After building most of my app, I assumed that i can have a relation between a field in Dataverse to a field in Sharepoint. I have not seen anything from the interface, and getting no specific information about this from the web.
Anyone have a definitive answer for this? I know the alternative is to have the table in DV and utilize Automate, OnSuccess or something (any ideas?) to post the data into the Sharepoint List subsequently, but i would rather not have to redo the existing db structure if i do not have to.
Thank you very much for your time 🙂
Ezra
But a definitive answer to you question would be No. Without changes and/or some workaround you cannot create a direct relationship to my knowledge.
From my experience a Lookup Column/relationships in dataverse will only allow you to lookup/relate to another dataverse table. You cannot Lookup/relate to another source. The closest I have come to something similar is fake relationships where all i do is write the sharepoint Row ID into the dataverse row/record and reference that where needed in lookups and filters in the canvas app.
In some scenarios I have used Dataflows/Power Automate to bring the sharepoint list into a new dataverse table and looked up to that.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1