cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Preston
New Member

DATA ENTRY POSSIBLE?

Good afternoon, 

I am new to PowerApps but I am an avid Excel user. I would like to setup an app for data entry purposes. I have a few questions....

1. Is it possible to have multiple users input data into the app via text input boxes and a submit button at the bottom?

2. If yes, would it also update the excel file in real time if it is stored on a OneDrive account. 

3. Could you pull/view reports from the file using the App?

 

Any of this possible with PowerApps?

1 ACCEPTED SOLUTION

Accepted Solutions
hpkeong
Community Champion
Community Champion

Hi:

 

https://powerapps.microsoft.com/en-us/tutorials/get-started-create-from-data/

... from LEARN Tutorial will tell you everything.

- You can either have data entered into Excel first and upload (in bulk, esp when you had existing bulk data), or

- Enter from App and saved (Button.SubmitForm when using create apps from data or use Patch(.....) if done manually) into Excel

 

You can use Excel stored in

- Dropbox (so far the fastest connection. within 3-5 seconds)

- OneDrive and Goole Drive (slowest, maybe 20-40 seconds)

 

Then, you can view it easliy using Gallery.

 

Hope this helps.

hpkeong

View solution in original post

4 REPLIES 4
rgruian
Power Apps
Power Apps

Hi Preston,

 

1. Yes, this is possible. You need an "Excel on OneDrive/DropBox" connection to accomplish this.

2. Yes, as long as it's stored on OneDrive and accessed via the connection above.

3. Reports are not supported. PowerApps can extract table information & data from .xlsx, and nothing else. Computed columns are also not currently supported.

 

I hope this helps.

 

Radu Gruian [MSFT] ** PowerApps Staff

Thank you for the prompt reply. So I got two yes's and a maybe/not yet. Sounds like I am on the right track. So now I have a second question (or fourth if your keeping track). How can I learn how to do what I previously asked? Following are two pictures, one of the APP and one of the Spreadsheet. Getting the data from the APP to the Spreadsheet is the goal. Any tips???

app.jpg

 

 

ss.jpg

 

 

hpkeong
Community Champion
Community Champion

Hi:

 

https://powerapps.microsoft.com/en-us/tutorials/get-started-create-from-data/

... from LEARN Tutorial will tell you everything.

- You can either have data entered into Excel first and upload (in bulk, esp when you had existing bulk data), or

- Enter from App and saved (Button.SubmitForm when using create apps from data or use Patch(.....) if done manually) into Excel

 

You can use Excel stored in

- Dropbox (so far the fastest connection. within 3-5 seconds)

- OneDrive and Goole Drive (slowest, maybe 20-40 seconds)

 

Then, you can view it easliy using Gallery.

 

Hope this helps.

hpkeong

View solution in original post

Just curious what you ended up using? My need are the same and trying to find a good solution. Thanks

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (921)