Copy and Paste Data from Excel into PowerApps

[tlevine]

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

[tlevine]

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

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

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

@Tqphan87 

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

[ohthreesixtyfiv]

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]

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

[WalnutMercury]

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:

C1	C2	C3	C4
Apple	Banana	Cherry	Banana
Apple	Banana	Cherry	Banana

Thank you! any help on the code is appreciated.

[SPRubi]

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]

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]

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