Upload csv file content to Sharepoint List in PowerApps

[balakowsalya]

Hi All,

I'm trying to add a feature to my PowerApp to let users upload any csv file from local and upload the content to Sharepoint List. There should be two options either to overwrite the already existing records in the SP list with the same name as of file name or append the new set of records to the existing SP list after validating the schema.

I'm able to get the file uploaded using Attachment Control and tried to upload the same to Sharepoint Doc Library using MS Flow. But for my use case, I want the records to be uploaded to an SP list.

Please provide your guidance!

Thanks,

Bala

@Nogueira1306 

[KajalGupta15]

1. Open up the Excel/ CSV file you want to import into a new SharePoint list and highlight all the data you want to import. 

1. Click ‘Home’

2. From the left hand side on the top panel, click on ‘Home’

   Click on ‘Format as a table’ and select any design of your choice

3. From the panel at the top, select ‘Format as a table’ and choose any design of your choice In the next window, click ‘OK’

4. When the small window appears asking where the data for your table is, click on ‘OK’ at the bottom.  Then, click in the search box and type ‘export’

5. While that data in your table is still highlighted, search ‘export’ in the search box in the top panel  ,Click on ‘Export data’ and then select ‘Export table to SharePoint list’,      

6. When the suggestions appear, Click on ‘Export data’ and then select ‘Export table to SharePoint list’ from the drop down list on the right. Go to your SharePoint site and copy the link

7. Sign into SharePoint if you haven’t already and enter the SharePoint site where you would like the Excel/ CSV file to be imported to. For the purpose of this demonstration, I will be using an example ‘Blog Demo’ site. Copy the link for your site. 

   Paste the link into ‘Address’,
8. Give the file a name,
9. Click ‘Next’.
10.  
11.  

[balakowsalya]

Hi @KajalGupta15,  I'm not sure if you have understood my query, I want to upload the csv file from PowerApps to update the records of the SharePoint List.

Mentioning for A2A, @PowerRanger @StalinPonnusamy @Nogueira1306 

Could you please help here?

Thanks!!

[PowerRanger]

@balakowsalya not 100% sure but the last time I had to deal with csv files and power automate I ended up in using an azure function to convert the csv into a json cause power automate had/has no build in csv reader. 

There  are blog posts out there how to read a csv but this was as far as I remember not that accurate. 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[HEATFreight]

What if the CSV has over 2 million records?

[chatgpt]

this helped me a lot: https://www.youtube.com/watch?v=uEZI_b1Gs-k