cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Oskarkuus
Level: Powered On

Let users import data in bulk?

How can i let my user ad many rows of data fast? Like allow them to upload an excelfile or paste data into a textbox where each row creates a new row and column are separated with a comma?

Is this possible?
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Let users import data in bulk?

Hi @Oskarkuus ,

Could you describe more clearly about "ad many rows of data fast"?

Usually, you could connect with one drive (upload your excel file to one drive).

Then you could use the data of excel file in PowerApps.

You could use gallery/data table/listbox to display many rows.

As your demands of "creates a new row and column are separated with a comma", I've made a similar test for your reference:

insert a listbox

set the listbox's Items:

AddColumns(tablename,"newfield",fieldname1&","&fieldname2&","&fieldname3)

Value choose the new field that you create.

Then the listbox will display the column that you want.


 820.PNG

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Dual Super User
Dual Super User

Re: Let users import data in bulk?

Hi @Oskarkuus 

 

Users can upload files to PowerApps

This uploaded file can be an excel file (which is based onm your data source definition - like a template) that users can fill out and upload to PowerApps

PowerApps can then call MS Flow which can then traverse through the excel file and bulk upload the data to your data source

 

Sending files from PowerApps to Flow using attachments control

https://www.youtube.com/watch?v=UYK7yruBHDM

Get rows from excel and send to SharePoint

https://www.youtube.com/watch?v=jTLJr4U_Gho

 

There are plenty of other examples available

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

 

Community Support Team
Community Support Team

Re: Let users import data in bulk?

Hi @Oskarkuus ,

Could you describe more clearly about "ad many rows of data fast"?

Usually, you could connect with one drive (upload your excel file to one drive).

Then you could use the data of excel file in PowerApps.

You could use gallery/data table/listbox to display many rows.

As your demands of "creates a new row and column are separated with a comma", I've made a similar test for your reference:

insert a listbox

set the listbox's Items:

AddColumns(tablename,"newfield",fieldname1&","&fieldname2&","&fieldname3)

Value choose the new field that you create.

Then the listbox will display the column that you want.


 820.PNG

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,116)