cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Re: DATA ENTRY POSSIBLE?

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
Power Apps
Power Apps

Re: DATA ENTRY POSSIBLE?

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
Preston
New Member

Re: DATA ENTRY POSSIBLE?

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

Re: DATA ENTRY POSSIBLE?

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

supreme436
New Member

Re: DATA ENTRY POSSIBLE?

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

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (5,434)