You’re offline. This is a read only version of the page.
41
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
To clarify your question you'd like a Dataverse table to have a lookup to a SharePoint list to be able to integrate the data together? If so this can be done by creating a virtual table for the SharePoint list and then making a lookup that points to the virtual table you created.
We have just announced the ability to create these virtual tables using a virtual connector provider which simplifies the process over the old way of building custom connections. For more info and how to videos check out this document: https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/create-virtual-tables-using-connectors?tabs=sql
Hi @PPG-Ezra ,
@AJ_Z is correct. There is no lookup that you can populate with a SharePoint list in Dataverse. Note, this might be coming sooner than later with Virtual Connectors though. Currently the Virtual Connectors is in preview and supports a SQL Server connection but they are looking to add more and I am hoping a SharePoint list connector is not far behind...
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
