Copy SharePoint List Structure and Contents to Dataverse Table

Поділитися
Вставка
  • Опубліковано 14 жов 2024
  • This video will walk through the process of how to copy SharePoint list structure and data to the Dataverse table using the Power Platform dataflow service. If you already set up a SharePoint list in the past and for whatever reason, you want to migrate the list structure and the contents to
    Dataverse table. This video will explain the SharePoint list to Dataverse transfer approach using PowerApps dataflow. You can also sync the SharePoint list with the Dataverse table using the dataflow approach discussed in this video.
    🔴 ** BE OUR FRIEND **
    ✅ Website: www.keapoint.com
    ✅ LinkedIn: h / 18782324
    ✅ Twitter: / kea_point
    ✅ Facebook: / keapointuk
    🔎 HASHTAGS 🔎
    #SharePointList
    #DataFlow
    #Dataverse

КОМЕНТАРІ • 24

  • @djsinjin
    @djsinjin 2 роки тому +1

    good job! I have never done this kind of work before and your video made it super easy to do. Thank you again.

  • @imotumbokanaka4157
    @imotumbokanaka4157 2 роки тому +1

    nice and direct

  • @chrismanning9646
    @chrismanning9646 2 роки тому +1

    Nice video! The only issue I found with this video is you migrated a SPO list with some choice columns. I tried to create a Dataflow to migrate a SPO list data with choice columns (some are multi-select choice columns) to Dataverse and once in Power Query, there are no choice column options so you are stuck with text column types. Can you explain how you successfully migrated those SPO list choice column types? Thank you.

    • @KeaPointTechTips
      @KeaPointTechTips  2 роки тому

      I think you will have to migrate it as text columns and change the column type to choice after migration.

    • @carlw
      @carlw 2 роки тому

      Yes, I've been playing with that too. Seems when migrating SP list data to Dataverse EVERYTHING is a text field. "NOT". I appreciate this video but Microsoft: That's the furthest thing from useful.
      I came to check out Dataverse and PowerApps in Teams and have had nothing but a negative experience. Nothing works as planned, everything is text field and trying to use SharePoint lists sure does not work properly in PowerApps in Teams. AT ALL contrary to every one with a video.

  • @mohitmishra962
    @mohitmishra962 2 роки тому +1

    In model driven app, I have added SharePoint document library. Is it pot to restrict users to only their own attachment and not all inside record?

    • @KeaPointTechTips
      @KeaPointTechTips  2 роки тому

      You will need to implement row level security in SharePoint which I do not recommend. Dataverse is a good option for you to host data.

  • @Sourabhsom1993
    @Sourabhsom1993 Рік тому

    Will data sync in dataverse in real-time if I update some column value in SharePoint lists ?

  • @saikiran4820
    @saikiran4820 2 роки тому +1

    Hi is it possible to delete the older records because every time its refreshing the older records are also getting in to table

    • @KeaPointTechTips
      @KeaPointTechTips  2 роки тому

      Yes possible, once record migrated to dataverse table, you can initiate delete old record , or better flag old record as archived.

  • @saradehond3293
    @saradehond3293 2 роки тому +1

    Is there a way to rename the Columns? Mine have become Field_1, Field_2, Field_3 etc....

    • @KeaPointTechTips
      @KeaPointTechTips  2 роки тому

      Yes, you can change the display name of the column.

  • @williamschubach5324
    @williamschubach5324 3 роки тому +1

    Hi, I want to archive folders and files from one sharepoint to archive sharepoint site!

    • @KeaPointTechTips
      @KeaPointTechTips  3 роки тому

      Hi William. That can be done easily. You need to build an archive site and write a schedule type power automate flow to archive the documents. We can help you with this set up.

  • @ARTURROArturro-pz7mh
    @ARTURROArturro-pz7mh 2 роки тому +1

    why when I refresh the data flow incrementally, the records are duplicated in the Dataverse?

  • @dgarg2149
    @dgarg2149 3 роки тому

    Hi..Can we migrate content from SharePoint online to Dataverse?

    • @KeaPointTechTips
      @KeaPointTechTips  3 роки тому

      Hi, this video explains how to migrate list contents as well as structure. but you can also just migrate SharePoint list contents to an existing dataverse table .

  • @ellgee9402
    @ellgee9402 2 роки тому

    but why is your assigned to string some random number and not the actual persons name?

    • @KeaPointTechTips
      @KeaPointTechTips  2 роки тому

      Sorry, I didn't get it.

    • @kranthikiran4558
      @kranthikiran4558 Рік тому

      I too can't figure out person field from sharepoint to user field is difficult.