cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Benogo
Frequent Visitor

Importing Data from an Excel File In a canvas App

Hello,

I am building a power app. The user receives an excel sheet of a shipment every week and he has to create a shipment in the app. The excel sheet comes with a standard set of columns. I need some advice with pros and cons of the options I have. See the data received in the table below:

Customer NameCustomer Code# PackagesContact MobileWeight (kg)
Cost ($)Shipment Number
Jeff Brade357TEST2123475654356.44SWIN-001-JAN
Test Ninja358TEST1352471231621.00SWIN-002-JAN
TEST NINJA404TEST3321487523849.56SWIN-003-JAN
  1.  Onedrive Excel File: Connect a Gallery to the excel file on Onedrive as a Datasource. When the user receives a new Excel file, he will go into the file on Onedrive and paste the new data. The app would refresh the data source with the Onvisible property of the screen. A create shipment button can then be used to create the records in the dataverse.
  2. Paste in Text Area: Text input area on a screen within the app. Data is copied from the excel table and when pasted in this text area it will populate a Gallery on the same screen with the same data. A create shipment button can then be used to create the records in the dataverse.
  3. Dataflows: Create a dataflow. I am not very comfortable with this because I am worried that it would break easily depending on how the flow is configured. I would appreciate help on the steps to configure the flow such that when a new excel sheet arrives it can be stored somewhere, the flow would detect the new file. Go into the file retrieve the data and create the record in the dataverse.
  4. Excel Power Apps Addin: Configure the adin to connect to the dataverse and allow the user add and publish data. This is probably not best practice.

Any other ideas for solving this is most certainly welcome.

 

Thank you.

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @Benogo ,

I have a blog on Option#2 that may be of assistance.

 

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.

Visit my blog Practical Power Apps

Benogo
Frequent Visitor

Thanks @WarrenBelz  I actually used some of the info to build the option 2 already. Just trying to see if it's a good way to solve the challenge.

 

Hi @Benogo ,

I do not use (for many good reasons) Excel and also do not dabble in Data Flows, so can only offer Option#2

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,062)