web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to import data fro...
Power Apps
Unanswered

How to import data from SharePoint list into the Note table in Dataverse

(0) ShareShare
ReportReport
Posted on by

We have an existing canvas app that is built on top of SharePoint, and we are in the process of migrating that app into a model-driven app that is built on top of the Dataverse.

 

We are using Power Platform Dataflows to migrate the data from SharePoint into the Dataverse.  We are 90% complete with this process, but we have the need to migrate the existing notes from the old app into the Note (schema name annotation) table in the Dataverse.  We want the notes to be associated with one of our custom Dataverse tables.  But I can't find any documentation on how to associate each note record with our custom table.

 

I see 3 columns that might suit my purposes:

  • ObjectId (aka "Regarding"): the documentation states that this column stores the unique identifier of the object with which the note is associated.
  • ObjectIdTypeCode (aka "Regarding Object Type"): the documentation doesn't say anything about this column.
  • ObjectTypeCode (aka "Object Type"): the documentation states that this column stores the type of entity with which the note is associated.

I'm assuming that I need to do the following:

  • Associate ObjectId with the unique identifier of the associated record in my custom table.
  • Associate ObjectTypeCode with the unique identifier of the custom table.
  • Not sure how to use ObjectIdTypeCode.

Anyone out there who has done this successfully via a Dataverse dataflow?  Or is this even possible?

I have the same question (0)
  • Jonathan Manrique Profile Picture
    2,687 on at

    Hi @ProtoPrimate 

     

    Of all the fields, the regarding is the most important, it is the one that associates the note with a record, that is, you can have a contact record and a note associated with this contact, since the regarding is the contact's GUID.

     

    Doing it with Power Automate is not easy, but you must know who you should associate each note with, otherwise the note will be orphaned and will not belong to any record.

     

    Maybe you have a way to identify which record the note belongs to, and you can work on it in an Excel where you can enter the GUID of the record and import it with the Excel file.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard