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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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