I have created an app for my construction company. This app allows my staff to create a new 'Project' (enter in job name, address etc) and then saves the job to the 'Dashboard'. Then on the Dashboard they can click an exisiting job and that brings them to a new screen that has a list of Phases throughout the job. E.G. Job start up, Demolition, Foundation etc. When they click on one of these phases, it switches to a new screen that has a list of tasks with check boxes. Here they can tick off tasks that they have completed. I want them to be able to save this information to each job so everyone can see the progress on each job site.
I am having issues with how to make this all work with data sources etc. I am using excel. I keep hitting brick walls though with recording new information for new projects. I have created each screen that I need but connecting it to all save is the problem I am facing.
Any advise would be wonderful! Thank you!
First off, I don't know the size and scope of your organization, but having worked many apps in that industry, I know those lists can get big quickly and with a lot of people interacting.
The reason I mention that is, Excel might become a bottleneck to you. Keep in mind when you use PowerApps with Excel, Excel should really be viewed only as a database, no longer as an interactive spreadsheet.
So...you might want to consider at least moving up to SharePoint now before you grow it too big to deal with in Excel.
Just a bit of advice.
Now...on to your post - Can you share some of the specific issues you are having. Are you running into errors you don't understand, or just stuck on certain things?
Thank you for the information. I am just having one login for my entire staff (to keep costs down).
When I create a new 'Project' and enter in the details etc about the job, I want that to save to the dashboard so I can access it at a later date.
Then if I select it on the dashboard at a later date, I want it to bring me to a list of 'Phases'. Then if I click on a 'Phase' it brings me to a new screen that has a checklist. I want to be able to tick off 'Tasks' and have it save to that 'Project name'. I am unsure how to do that with Excel etc.
Right now, I have my check boxes but when I go into the 'Play' mode, it is not saving the information for each 'Project' separately. It is just keeping the ticks in the boxes regardless if I click 'Project 1' or 'Project 2'.
Yeah...you're going to need to be more specific on an issue and provide some formulas, screenshots, etc. to go by.
I understand in general what you are saying, but without seeing anything, it is hard to pinpoint where you are having a problem.
So, what kind of formulas do you have that you feel aren't working or you are stuck on?
Ah yes, then you will definitely need to get some formulas in your controls and tie them to the proper data.
If you are not familiar with these things, I'd highly recommend going through some of the sample apps in PowerApps. Most all of them use Excel as a datasource and they will have lots of things to look at. I'd pick some simple ones to keep from getting overloaded.
BUT...in general, you're going to need to connect to your data, put in some formulas for controls in some places, and then deal with issues along the way.
If you've not viewed videos and other training materials on PowerApps, I'd highly recommend doing that also.
No problem at all. Please keep at it and learn it - you'll find it very valuable.
And, as always, if you get stuck on a particular (and specific) area - post here often. Lot's of good minds on this forum to help out.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.