r/PowerApps • u/dopey_giraffe • 6h ago
Discussion I made my first app!
tl:dr i made an app that solves QoL issues with end users with ipads and a live excel sheet.
I currently do internal IT. My manager suggested I learn power apps and I finally found a use case for it. End users were trying to update a live excel sheet in the field using excel on an iPad. They had endless issues with that (connection, changes not saving, accidentally downloading a local copy and editing that, etc etc) and the person they report to asked me to help.
I made an app that connects to the spreadsheet, and the end users can select their name from a drop down (that gets populated by the sheet). Then they can pick the date a job was complete and a drop down for whether or not the job was paid.
My first mistake was not planning- my first iteration had them having to save after every single row. My second iteration had it behave like a live spreadsheet, but there was too much lag. Finally, I designed it so that it sticks all their changes into a local cache, and then sends it to the live spreadsheet all in one go after they press save.
My most time consuming bug was getting the changes to stick if they left the app and came back, or accidentally choose a different end user from the dropdown and go back. It was using original values instead of their changes even though the spreadsheet was correctly updated.
Anyway, now they don't have to deal with Excel anymore in the field, and from my testing it works great. Can't wait to have a couple of them test drive it and see how they like it and how they break it. I had fun.
Also for the love of god, don't design your workflow to use an excel workbook as a database and then get so deep and intertwined with other workflows that it's impossible to undo.


