Skip to main content
Community site session details
Power Apps - Microsoft Dataverse
Answered

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

Like (1) ShareShare
ReportReport
Posted on 21 Mar 2022 18:38:53 by 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

Categories:
  • Verified answer
    AJ_Z Profile Picture
    3,711 Super User 2024 Season 1 on 21 Mar 2022 at 22:10:14
    Re: Possible to have a field in Dataverse as a lookup to a SharePoint list column?

     

    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. 

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics