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

Multiple input rows like excel

I have a sharepoint list and a powerapp. The powerapp have a page where I want users to input data that will go into the list. But user have there data in excel and sometimes it's like 400 rows of data and they dont want to input them for 1 hour. Is there a way to make a powerapp that will take a copy input from excel and paste it in a powerapp?
1 ACCEPTED SOLUTION

Accepted Solutions
rebeccas
Community Champion
Community Champion

No, not through PowerApps. There are a few ways around that you could do.

 

One would be have a blank excel spread sheet that is formatted they can get to and they can paste the values there and then trigger a Flow that takes that data, puts over to SharePoint list and then clears the data.

 

Basically you will have to think outside the box and use some tools outside PowerApps for that. Wish that would be an added option like Access does.

View solution in original post

2 REPLIES 2
rebeccas
Community Champion
Community Champion

No, not through PowerApps. There are a few ways around that you could do.

 

One would be have a blank excel spread sheet that is formatted they can get to and they can paste the values there and then trigger a Flow that takes that data, puts over to SharePoint list and then clears the data.

 

Basically you will have to think outside the box and use some tools outside PowerApps for that. Wish that would be an added option like Access does.

varnima
Frequent Visitor

In fact there many ways. I made flow with microsoft forms for single input, or even custom view for a list, so they can imput that what with quick edit. And I know the way that you mentioned, but I really wanted to give a more premium way of doing it. Like to put everything in the app. It's ok if it's not possible, that give me the reason I couldn't find the answer by myself.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,118)