Hello,
I've read that my excel data that I'm connecting to needs to be in a table on a cloud service. I have been able to generate what seems to be a functioning canvas PowerApp from a data-only table within an excel file. However, I am hoping to be able to integrate a PowerApp with a excel table (possibly with macros) that has formulas and calculations within the excel table.
For example, I have an excel table that has columns for ID# of the row, then 3 columns for separate numbers (int) for that ID#, and then I would have columns for relatively simple calculations such as sum, average, and perhaps number ranges for standard deviations. Is it at all possible to connect a table such as this to a PowerApp?
Ideally, I would like the PowerApp to feed the ID# and the 3 ints into the excel sheet, the excel sheet could run the calculations, and then display the 3 fields within the PowerApp as well as storing the calculations and data within the excel sheet. Is this beyond the current capabilities for the PowerApp system, or is there some way that I can build this? I've been trying to figure out the best way to do it, and so far I've been discouraged when I read that PowerApps can't connect to excel tables with formulas or anything besides plain data (and html addresses/pictures?).
Thank you so much for your time!
