How To Import Excel to Dataverse using Dataflow

Поделиться
HTML-код
  • Опубликовано: 1 дек 2024

Комментарии • 38

  • @yeraldo05
    @yeraldo05 3 года назад +3

    Daniel I think you are watching my browser history, because all of your latests videos and focusing in the things I'm developing about! Great Videos!!
    Always going the extra mile!! ⭐👌🏻

    • @DanielChristian19
      @DanielChristian19  3 года назад

      Very glad to hear that, Yeriel. Let me know if you have any videos in mind.

  • @KeyserTheRedBeard
    @KeyserTheRedBeard 2 года назад +2

    spectacular video Daniel Christian. I killed that thumbs up on your video. Always keep up the solid work.

    • @DanielChristian19
      @DanielChristian19  2 года назад +1

      Your welcome Keyser.

    • @KeyserTheRedBeard
      @KeyserTheRedBeard 2 года назад +1

      @@DanielChristian19 no problem at all. always happy to support my fellow content creators. i am looking forward to improving on my own current video format i have uploaded and, in the future, trying to create content as good as yours in the long term.

  • @crwebers
    @crwebers 2 года назад +1

    Thanks for video Daniel!

  • @PowerAppsTutorial
    @PowerAppsTutorial 3 года назад +2

    I expect to see the Santa hat all month long! 😊👍👍

  • @fzawadi
    @fzawadi 3 года назад +1

    Fantastic Video with highly valuable information. Thank you so much.

  • @carolcunha517
    @carolcunha517 6 дней назад

    I love you. Thank you so much!

  • @djfigmasta
    @djfigmasta 2 года назад +7

    At 3:40, when you talk about the 4 names you saw after selecting your file, based on the icons, i think 2 are the tabs and the other 2 are tables

    • @DanielChristian19
      @DanielChristian19  2 года назад +2

      Thanks DJ Fig, I realized that after I had published and uploaded the video. Like everyone, I too am learning new things 😀

  • @juandavila4035
    @juandavila4035 3 года назад +2

    Very good video! Thanks

  • @trevbraith4746
    @trevbraith4746 2 года назад +1

    Very Nice Daniel😀!

  • @MustafaFarooq
    @MustafaFarooq 3 года назад +2

    This was an excellent video for someone like me whos trying to learn Dataverse 👍, im looking forward to more if this is gonna be series ,would be good explore all the goodies of Dataverse in conjunction with the knowledge we gained from this channel on Power Platform, looking at the security aspects of Dataverse as well and maybe even how some more commonly used datasources can be connected.

    • @DanielChristian19
      @DanielChristian19  2 года назад +1

      Hi Mustafa,
      I am working on building a defined playlist with the focus on Dataflows.

  • @DavidShure
    @DavidShure Год назад

    This really is great and I will use it for sure. But I am also desperately trying to find a way to upload data into an existing Dataverse table straight through a Canvas app. I have users that wouldn't want, or be able to, go through the process of power query. Is there any way to build in an upload button inside the app? Not to attach a file, but actually upload rows of data to an existing table. I love your videos Daniel. Thank you.

  • @JasonAngWeiLung
    @JasonAngWeiLung 2 года назад +2

    Daniel, thanks for introducing me this way to integrate the data into Dataverse. My question: if the Onedrive excel file is modified, will the data automatically refreshed into Dataverse table?

    • @DanielChristian19
      @DanielChristian19  2 года назад +1

      Yes, it works as a one-way sync from Excel to Dataverse. Name your Dataflow to something that names sense and keep an eye on it.

    • @JasonAngWeiLung
      @JasonAngWeiLung 2 года назад

      @@DanielChristian19 just watched ur video about the data flow via power automate. Helpful for me!

  • @yoginathbadadale
    @yoginathbadadale 3 года назад +1

    Amazing 🤩

  • @sundrapillay6668
    @sundrapillay6668 3 года назад +1

    Thanks Daniel can you share spread sheet as I would like to test the import

    • @DanielChristian19
      @DanielChristian19  3 года назад

      Hey Sundra,
      Thanks for your support. The spreadsheet is part of the Power Apps App In a Day. Here is the link to download the content aka.ms/appinaday

    • @sundrapillay6668
      @sundrapillay6668 3 года назад

      @@DanielChristian19 Thanks Daniel

  • @chrismanning9646
    @chrismanning9646 3 года назад +1

    Great video Daniel! Can you direct me to a video or article that details how to migrate SP list data with choice columns (including multi-select choice col types) to Dataverse? I have yet to find such a video. Perhaps you can make such a video next.

    • @DanielChristian19
      @DanielChristian19  2 года назад

      Hi Chris,
      That is on my to-do list for sure. Thanks for the compliment.

  • @spen2431
    @spen2431 3 года назад +1

    Thanks Daniel. Very informative as always. 💥 One question - Why? Why use Dataverse over the Excel spreadsheet? (Both were online...)?

    • @DanielChristian19
      @DanielChristian19  3 года назад +1

      Good question! Dataverse is more robust than Excel and has the option to build relationships as well. To learn more about Dataverse take a look at this video where Reza and I interviewed Ryan Jones. ruclips.net/video/VgX2BIdEdqs/видео.html

  • @xMastJedi
    @xMastJedi 3 года назад +2

    3:17 + Here you have TWO sheets and TWO tables. Top 2 icons - Devices2 and Manufacturers1 they are TABLES in your spreadsheet. 3rd and 4th icon - Device and Manufacturers they are SHEETS on your spreadsheet.

    • @DanielChristian19
      @DanielChristian19  2 года назад +1

      Hi xMast Jedi,
      I'm by no means an Excel PRO so thanks for educating me.

    • @xMastJedi
      @xMastJedi 2 года назад

      ​@@DanielChristian19 Hi Daniel, thank you for the answer. Sorry for my previous post. I think I overreacted a bit. I changed the post. Please accept my apologies.

    • @DanielChristian19
      @DanielChristian19  2 года назад +1

      No worries. xMastJedi.
      We are all learning 😊

  • @v75tan
    @v75tan 9 дней назад

    I am facing a challenge using Dataflow to migrate data in Dataverse.
    multiline text is wrapping in one line
    Table.TransformColumnTypes(#"Promoted headers", {{"dml_relaynotes", type text}})
    Please help