Showing results for 
Search instead for 
Did you mean: 

Copy and Paste Data from Excel into PowerApps

Looking for the ability to copy and paste data from an excel table with multiple rows directly into PowerApps.

Status: New

How would the app look that would accept the table of data?  Is it a form?  Or a data table / grid?

Kudo Kingpin

@dyoder  - thanks for sharing this idea. Quick question on this. In order to have this work, do you have a document saved in a one drive or sharepoint library? Or do you have the user submit an excel file through powerppas where the flow will pick up the data?

Regular Visitor

@tlevine - Yes the Flow watches a folder on our Sharepoint drive, when a file is saved the Flow begins. Depending on the type of data and your use for it there can be a few issues to consider. File type, formatting and duplicating data are a few. So far I have been able to add small steps to the Flow to handle those.

Advocate I

@dyoder , This would have been the best route only if the excel data is in a table. Since the company's goal is automation, having the user format every excel into a table just to run a Flow wasn't ideal. Still the biggest drawback for me with Excel and Flow. At least Power BI can read CSV. 

Forever waiting for Microsoft to release the ability to create named ranges (table) on existing data.  

Regular Visitor



That is why I had Flow modify the file and create the table for me.

Advocate I

You can do this using the Split() and Char() functions!


See the following example:


To get the Rows you can set up your formula like so:


Split( TextInput.Text , Char(10) )


You can take the result of that to get the Columns like so:


Split( Split( TextInput.Text , Char(10) ), Char(09) )



Kudo Kingpin

It looks like maybe the new Lists feature will be able to provide a solve for this

Frequent Visitor

Hi @CP0822 

Thanks for your code,

I just tried your code and was wondering if you or someone on here can help me, please?

Looking to past from Excel (1000+ rows) but when I use the code below on the OnSelect of a Button, it errors out with:

Name isn't Valid, The identifier isn't recognised

Invalid number of arguments, received 1 Expected 2.

 Mainly on the RESULT in the Split, and the use of ;




I tried changing the code to use the TextInput3 Instead of Result, and that seemed to work but I couldn't get a Carriage return after the last Column.


Excel is pasted into the TextInput3 as follows:

Apple, Banana, Cherry, Banana, Apple, Banana, Cherry, Banana


I'd like it to output as follows:



Thank you! any help on the code is appreciated.

Advocate I

For my use case I found an option - maybe it could help you too:


It's just copying the values into a text field, submit it to a Flow and create items in the data source.

Regular Visitor

I would propose this feature to be added as an editable mode of DataTable. Similarly to the “quick edit” functuonality in sharepoint, users would be able to edit data in an excel-like grid, which allows copy-pasting ranges of cells. 

Advocate I

@dyoder ; Can you share how you were able to read in an Excel? Does the file have to be static with the columns and/or rows for Flow to read it?