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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard