Unanswered

Best Pracrice for Bulk import in Canvas App

(0) Share

Report

Posted on by tapper

Hi,

Im looking for some advice on a way to allow users of a canvas app to bulk import a table of data. I have come to a dead-end with trying to import an excel file/table on their local machine and the only way I can see how to do this is to copy and paste the table from excel into a text input, then split the text by a delimiter (tab) and push the result into a collection.

This would make for a pretty awful UI, so I'm wondering if there is any other way?

note, this is not related to bulk importing data when creating/editing the app, this is bulk import while users are running the canvas app.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @tapper ,
What is your data source - I can help you with SharePoint, but not other.

Was this reply helpful? Yes No
tapper 28 on at

Like (0)

Report

Hi, the data source is a .xslx or CSV, but I'm open to changing this as the app matures.

At its heart, I'm looking for the best way to bulk import data into Power Apps from a user perspective, instead of having to key in 50+ lines of data each time they have to report stock levels.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @tapper ,
If you make the table area big enough in Excel, you can cut and paste into this - we actually do this with reference data supplied by a customer into one of our few remaining Excel sheets. You can also do this in SharePoint in a datasheet view (new records) - you just have to make sure they are done in batches, the size depending on the number of columns to avoid throttling.
Is this what you are referring to?

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.

Was this reply helpful? Yes No
tapper 28 on at

Like (0)

Report

Hi,

Thank you so much @WarrenBelz for your quick response.

I think it may be me not quite grasping your reply, but the issue im having is importing from Excel into the Canvas App (not app to excel export).

Would you be able to expand on your response if your solution is regarding importing the data into PowerApps?

Thanks
Steve

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @tapper ,
Power Apps does not have data of its own - it needs a data source such as Excel or SharePoint. You can connect an Excel file stored in OneDrive and as I suggested, make the table area big enough to paste in new data. I would however for many reasons recommend SharePoint in preference to this. My comment there was that you can paste Excel data directly into a SharePoint Datasheet view set up with the same columns and order. You just have to do them in batches.

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.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @tapper ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No