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.

View solution in original post

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_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,646)