Import Excel data to SharePoint list with Power Apps

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ต.ค. 2024

ความคิดเห็น • 15

  • @amritkalash6750
    @amritkalash6750 4 หลายเดือนก่อน

    Great video, helped me a lot, thanks!
    Can you make a video on the entire app you have created? I have a similar use case

  • @Arthuro3513
    @Arthuro3513 2 หลายเดือนก่อน

    I would like to thank you for share your knowledge, it helped me a lot in a project in the company I work for.
    I have something to ask ... How can I hide the display message after a sucessfull import (the one created trought "varResponse") ? Everytime I re-open the import box the message is still there after the first import
    Edit: fixed by adding a button with OnSelect: "Set(varResponse: " ")"

  • @franceschiguillaume5870
    @franceschiguillaume5870 2 หลายเดือนก่อน

    Hi Deepak and thanks a lot for your video and the insightful ideas in it. I've had a hard time building an app that is almost doing the same thing as yours and I'd love having your recommendations. I'm trying to build an app that allows the user to upload a text file and send the content of that file to a Power Automate flow. Then Power Automate will use this file content, process it through a script and then write the result in an excel file. Should I retrieve the content of my file the same way you did it in your video or is it different regarding my text file? And last question : is it mandatory to create a temporary file to memorize the data before processing it in my script?
    Thanks a lot in advance for your help
    Guillaume

  • @emmanuelwatson93
    @emmanuelwatson93 4 หลายเดือนก่อน

    Great video - Just a quick question- When the file is uploaded how can we clear the last entry as when the users attempts to upload a new file the old file is still appearing.
    Thanks again

  • @mikelauritsen553
    @mikelauritsen553 2 หลายเดือนก่อน

    You need to add the word table to your description. It’s 14 minutes in before you realize that you have to have the data in a table format.

  • @shaikhayan2207
    @shaikhayan2207 4 หลายเดือนก่อน

    Appreciated👏

  • @shankarviz
    @shankarviz 12 วันที่ผ่านมา

    Deepak, i have given the same site address and folder/path in create file and location and document library in list rows present in a table as like you . but for me its throwing an error stating the path drive not found in list rows present in a table. can you please help me on this to fix.

  • @harishsharma19
    @harishsharma19 4 หลายเดือนก่อน

    Hi Could you please mention what's the visible property for the Text Label to show the success message.

  • @seshadrir85
    @seshadrir85 3 หลายเดือนก่อน

    what if the file is saved in subfolder within the sharepoint.. not able to get the list for the document library

  • @JiteshDhumal-q2n
    @JiteshDhumal-q2n 4 หลายเดือนก่อน

    Hello Deepak,
    I have a quick question. My Excel file contains 4000 records, which might cause the flow to take some time. If I want to display these Excel rows in a PowerApps gallery quickly, can you suggest a solution?

    • @dankirchner4460
      @dankirchner4460 2 หลายเดือนก่อน

      I've ran into the same concern. What I did is at the end of the flow send an email to the user telling them their data has been imported and is ready to view.

  • @dankirchner4460
    @dankirchner4460 2 หลายเดือนก่อน

    Hello. Im getting an access denied error on the create file step. But i have full permissions to the SharePoint site im using. Any idea how to get throigh this?

    • @joshuafernandes2641
      @joshuafernandes2641 2 วันที่ผ่านมา +1

      Is it the excel file is locked error? I'm facing the same issue.

    • @dankirchner4460
      @dankirchner4460 2 วันที่ผ่านมา

      @@joshuafernandes2641 it is