HI, I am fairly new to Power App but learning it.
I have a Excel file with 3 tabs and Projects related to Actuals, Budget and Forecast in each tab. Each tab contains same format and columns.
Please see attached screenshot. Green cells will be locked always and non editable.
Users will update in Orange cells all the time.
And like this we have like 20 different categories and all together like 150 Columns.
So is it worth to keep backend excel file and front end Power APP so that user can update Orange cells via App?
If yes, Should I need to create multiple screens in Canvas App for each Group and then Investment Area etc?
Please suggest. I really need help on this. I am curious to build this project. Or any new way to build this?


Report
All responses (
Answers (