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
FilipK
Power Apps
Status changed to: New

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

tlevine
Kudo Commander

Hi @FilipK - thanks for the response!

 

I envision this capability being in two poential forms:

 

1. Data Table - where the table can be blank and data could be copied and pasted from excel and then Patched/Saved through the app

2. Gallery capability - where you can copy data and have each line from an excel table copy into the invividual rows of the gallery.

 

 

CP0822
Helper I

Hi,

 

@tlevine How can I do this? I'm very interested in something just like this

 

Thanks

 


@tlevine wrote:

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




 

tlevine
Kudo Commander

Hi @CP0822  I don't have a solution for this but it would truly be a game changer for some of the apps I am looking to build! Hopefully @FilipK  can help us with a solution 🙂 


CP0822
Helper I

@tlevine 

Ok,

 

I´m pasting the data from Excel in the input text and then I tried to split the text and then saving this info in a collection but without success at the moment.

rfonsec
New Member

@CP0822 @tlevine - I have seen that solution before but for me it is not clean and user friendly. the recommendation here of simply using a data table with copy and past function would make this significantly easier. thx

CP0822
Helper I

@rfonsec Sounds useful to me, where can I find this information you mentioned?

simb55
Advocate II


@CP0822This functionability is not available yet. It is suggested on this forum right here to the Microsoft PowerApp Developers. If enough users vote for it, it may get the attention of the Microsoft crew.

 

So if you don't mind, please consider to sign up and hit the 'Thumbs up' button at the top of the page. 🙂

CP0822
Helper I

Hi @simb55 

 

Actually, I found a way to do it using split and for all function pasting the information in a Textinput and creating a collection.

 

I can share with you this code if you need it.

 

Thanks.

Zeuthen
New Member

Hi @FilipK,

 

Are there any news whether the above functionality is on the road-map?

We are quite a bit of people, where this functionality would make PowerApps much much stronger to us, as we have to revert to excel every time at the moment.

 

Thanks!