Hi,
I have been brainstorming this for a while and would like to see if anyone else has got any smart ideas for the following.
My company has set process in how we go about planning parts for Engineering and Quality controls.
We have multiple forms that are controlled with company form numbers and are Issue controlled. This is to document any changes to columns, or changes to the process.
Currently these are all Excel forms, and where required, utilise VBA. We have 1 that is a planning tracker that keeps track of the part planning progress. We use this for when we are re-planning existing parts, and when we are planning brand new parts. We have another for the 'NPI Meeting Minutes' to document what is discussed in the New-Part-Introduction (NPI) meeting. Then we have a last one that is for when the part is Planned by Engineering and planned by Quality (These forms then get placed into a database that we can interact with to find how many parts have 'x' process or how many parts we make from 'x' customer etc).
I am in the process of re-vamping in particular 1 form, but while I've been doing this I see an opportunity to move our whole part planning process onto PowerApps and literately make a App that holds every form, or table databased etc required for planning a part. It would allow for a smoother process and easier navigation between forms etc. And also, scalability!
My issue is this:
How do I move these forms onto PowerApps where users can interact with them while also keeping the forms Issue Controlled?
My first thought was to just use galleries or the new 'Data Grid' or 'Table' components but I can't figure out how to make, especially the Planning Tracker form, easily editable as parts progress. The ideal would be to have in-line editting, like how you have in Excel. I don't want to over-use the 'Form' style.
I have thought about using sharepoint lists, but it would lose all Issue control.
My main issue is keeping the forms as excel, but making the dynamic enough to be editted from PowerApps.
Any help with this would be massively appreciated.
