cancel
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?

Comments
tlevine
Kudo Commander

@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?

dyoder
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.

Tqphan87
Frequent Visitor

@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.  

dyoder
Regular Visitor

@Tqphan87 

 

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

ohthreesixtyfiv
Regular Visitor

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

 

See the following example:

https://twitter.com/ohthreesixfive/status/1261364880248111106

 

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) )

 

Cheers!

tlevine
Kudo Commander

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

WalnutMercury
New Member

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 ;

 

ForAll(Split(TextInput3.Text;Char(10));Collect(TotalCollection2;C1:First(Split(Result;Char(9))).Result;C2:Last(FirstN(Split(Result;Char(9));2)).Result;C3:Last(FirstN(Split(Result;Char(9));3)).Result;C4:Last(FirstN(Split(Result;Char(9));4)).Result;C5:Last(FirstN(Split(Result;Char(9));5)).Result;C6:Last(FirstN(Split(Result;Char(9));6)).Result;C7:Last(FirstN(Split(Result;Char(9));7)).Result;C8:Last(Split(Result;Char(9))).Result}))

 

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:

C1C2C3C4
AppleBananaCherryBanana
AppleBananaCherryBanana

 

Thank you! any help on the code is appreciated.

SPRubi
Advocate I

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

http://4us2use.at/?p=315

 

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

AkosB78
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. 

Tqphan87
Frequent Visitor

@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?