I just started learning PowerApps today. In general, is PowerApps designed to import just static data from Excel? I have a very functional Excel file but I can't seem to import any data that was generated from a function. If my cell is simply the number 4, it will import. If the cell is "=2+2", it will not. I assume that all functions are do be done in PowerApps. Is this right?
You can connect to satic database or you can create a connection from your or company onedrive dropbox etc and update record delete record do all kind of calculation and modification as you wish.. There are a lot of video on youtube so I think you can try to start there