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?


Report
All responses (
Answers (