Hi all,
I'm really struggling here to find a solution to a problem I'm trying to solve after googling, youtubing etc to find similar issues/solutions.
Not being able to connect PowerApps to Excel tables that contain formulae is the crux of the problem here. I've attached a super basic excel file financial model where I would like to be able to show a chart of the cash flow in row 13 on sheet 1/column B on sheet 2 (now with hardcoded values but needs to be somehow 'live'). Using PowerApps I would like to be able to change some of the variables on Sheet 1 through PowerApps and see the change in the cash flow chart in PowerApps.
Is this possible? To me it sounds super basic and achievable but can't quite get my noggin around it. Perhaps I'm being slow having just returned from a short break!
Any help much appreciated.
Matt