Unanswered

Users can upload CSV in canvas app directly into dataverse table

(0) Share

Report

Posted on by furgun

Hey community,

is it possible to allow users to upload a csv file within a canvas app? The content of the csv file should then be imported directly into a dataverse table. I dont want to use sharepoint. It is not necessary to store the csv file anywhere in power apps. Its only purpose is to provide data to the dataverse table.

I need this function in the canvas app, so the users can upload any csv to extend the dataverse table with new data.

Shorter version of question:

1) How can I implement a function in a canvas app to upload csv?

2) how can I read the data from the csv

3) how can i store this data in an existing dataverse table (and how does the column mapping work)?

thank u !

best

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

SagarVIS96 212 on at

Like (0)

Report

Hi @furgun ,

You can create a File datatype column in dataverse table and then use that column to upload any type of file. In you case you can upload CSV as well.

To read data from CSV you can use visit this link for reference:
Uploading Files to SharePoint Document Library from Power Apps (c-sharpcorner.com)

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @furgun ,

Are you planning to create/update records as per uploaded CSV and map records in desired table?

If yes, don't use Canvas app to carry out this process.

You can try going to Model-driven App's advanced settings -> Data Management -> Data Import -> Upload your CSV file and select mapping (You can store mappings as well, so when you upload next time, you can select same mapping and efforts are reduced)

This method is regards to mapping CSV to dataverse tables.

Now, let's come to saving file in dataverse, you can use methods provided by @SagarVIS96

1st way is to create file column datatype which will store file in dataverse itself.

2nd way is to create a SP site which will be connected to your model-driven app. You need to enable SP Documents for the Table you want to use SP location.

When you are on the record, a Tab 'Documents' will contain a grid where you can efficiently drop/upload files in them.

Note: You can also use Power Automate to upload/remove files automatically or call flow from Canvas App if needed.

Hope this helps

Was this reply helpful? Yes No