Hi All,
Recently started a new controller position for a manufacturing company. I would consider myself an advanced excel user with some Power BI experience, overall Microsoft savvy, but haven't really utilized PowerApps or any of the developer type tools.
The company has recently moved from Google Workspace to Office. The good news is a fair amount of data is being collected, however, much of it is in shared excel sheets that aren't formatted in a way to generate much reporting. A lot of data entry being done is redundant, given these sheets are not connected. The production schedule that the operations team is using is being managed by a shared outlook calendar (one event per SKU being ran).
The team really desires to keep a calendar view of the production schedule (preferably with an outlook calendar so multiple calendars can be viewed in one place). My initial thought was to use SharePoint Lists as a place to schedule production and then log production results with various lookup columns to reduce entering the same customer, SKU information, etc. multiple times. However, there should be different permission levels, where production employees should only be able to see production related fields, while the exec team will want to see estimated revenues by production date, customer, etc. Also, the production schedule "calendar events" often need to be edited, and it didn't seem like there was a clear connection with a SharePoint list to an outlook calendar. Our external IT help (mostly hardware based support) recommended looking into PowerApps.
Does this sound like something that would be best built in PowerApps? Also, where would you recommend starting in terms of learning how to use PowerApps for this purpose?
