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.
2 REPLIES 2
RezaDorrani
Level 10

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.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 62 members 4,834 guests
Please welcome our newest community members: