I am new to Powerapps and absolutley hooked, I have fair expeirence with Access and exel and just need some help with my app that i wish to build - any assistance would be greatly appreciated.
The App is going to contain circa 7 fields of data that is stored in an excel file on OneDrive, I cant use sharepoint as this is restricted by my company. The app users will be an internal team and they will need to be able to view the data and add if they need to.
The Data look like this:
Field 1: System - Text
Field 2: Asset Type - Text
Field 3: Manufacturer - Text
Field 4: Model - Text
Field 5: Manufacture Date - Text
Field 6: Comments - Text
Field 7: Record Date - Date
So the plan is the user will land on the system page: This has data like Electrical, HVAC, Refrigeration.... When the user selects one, then that will cascade to another screen showing only the Asset Types relevant to the System. The user then can select the Asset Type and that will cascade to another screen with all the possible Manufactures. And it continues to flow.
Electrical / Distribution Board / MEM / Isobar 4 / "Last Page" Includes the Manufacturing Date, Comments and perhaps a record date.
So i have created all the screens and linked the data, somehow need to work how to link them up? So my first screen is System, but it seems to show duplicates which i dont want it to do. It all looks good but doesnt function
On the top of each screen i want to go back a page and the user alo has the ability to add a new record from the app. This isn't a show stopper though.
Thank you for taking the time to read this and I hope that I can get some help.