Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Power Pages - General Discussions / Import excel or csv da...
Power Pages - General Discussions
Suggested answer

Import excel or csv data to dataverse table from power pages

(1) ShareShare
ReportReport
Posted on by Viktor Kralevski 8
Hi, 
 
I am trying to import excel data to dataverse table from power pages portal. Currently, there is an option for the logged in users to submit offers one by one, and in some cases it is very time consuming. The idea is to have the users pre-prepare his offers in an excel file, and to give an option to them to import it instead of typing it manually. 
 
Is this even an option in power pages? Any idea or link to a documentation would be very helpful :)
 
Thanks,
Viktor
 
Categories:
General
  • Viktor Kralevski Profile Picture
    Viktor Kralevski 8 on at
    Import excel or csv data to dataverse table from power pages
    Thanks Fubar, SaiRT14,
     
    Managed to do this with Fubars approach. 
     
    Best regards,
    Viktor
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 10 on at
    Import excel or csv data to dataverse table from power pages

    • Custom File Upload and Processing: Set up a custom form on Power Pages for Excel uploads, then use Power Automate or a custom API to parse and insert data into Dataverse, tailored to your needs.

    • Dataverse Excel Import Feature: Direct users to utilize Dataverse's built-in Excel import functionality, allowing them to upload pre-filled templates directly into the Dataverse table.

    • Use Power Apps Component Framework (PCF): Develop a PCF control for the portal, enabling users to drag and drop Excel files, which are then processed and imported into Dataverse for bulk data handling.

  • Suggested answer
    Fubar Profile Picture
    Fubar 7,351 on at
    Import excel or csv data to dataverse table from power pages
    If you can see the File, but when you try to open if in Flow or something else and the contents are not correct other than when in a Model Driven App interface (e.g. if you can click on it in a Model Driven app and it is ok, but not in Flow etc), you need to encode/decode it as the file probably Base64 encoded 
  • Viktor Kralevski Profile Picture
    Viktor Kralevski 8 on at
    Import excel or csv data to dataverse table from power pages
    Thanks Fubar, meanwhile I've managed to this, and indeed the file ends up in the Notes table.
     
    But, I am wandering what is happening with the file because it looks to me that the file is saved in Notes in other type of file - I am importing Excel file, but not able to do anything with it later.
     
    For example, I have saved it on one drive, but any of the one drive power automate components do not work with it while the list file option finds the file (it exist on the location with expected name)
     
    Thanks,
    Viktor
  • Suggested answer
    Fubar Profile Picture
    Fubar 7,351 on at
    Import excel or csv data to dataverse table from power pages
    There is not an existing function to do this, but it can be done. However, there are also some things to consider such as validation of the data in the file (and what to do if it fails any validations), what to do if the file being uploaded contains a virus/malware., and what file size and types you will accept,
     
    The general process would be to create a Form that either has a File field on it or that is enabled for attachments (in which case the file will end up in the Notes table). Then run a process when the form is submitted to retrieve the file and process it - you may be able to use Flow for this. 
     
     

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update 9/9/24…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,690

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans