Answered

Possible to have a field in Dataverse as a lookup to a SharePoint list column?

(1) Share

Report

Posted on by PPG-Ezra

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (4)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

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...

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/virtual-entities/create-virtual-tables-using-connectors

Was this reply helpful? Yes No
Nhelgren Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
flavio_ferrari 3 on at

Like (0)

Report
Copy link

Link copied!

A couple of years passed, do you know if there a solution to this now?

It seems odd since the connectors in Access from Sharepoint are working properly just dragging primary IDs and fields to be shown.

Was this reply helpful? Yes No