Help with dynamic PowerApps financial model

(0) Share

Report

Posted on by Cattymakes

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

PowerApps test mo...

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

PN-13051647-0 22 on at

Like (0)

Report
Copy link

Link copied!

Any luck with this? I have been looking for months for a solution to the same problem.

Was this reply helpful? Yes No
Suggested answer

pavanmanideep 503 Power Up Champ - 2025 on at

Like (0)

Report
Copy link

Link copied!

Hi There,

Excel formulas will not work when a Power App is created based on excel sheet.

It looks like your formula you have in excel is a basic CRUD operation, you can load the excel data and then you can use Power Fx to calculate below..

Revenue
Cost
Operating cash flow
Capex
Net Cash flow

You can check https://www.youtube.com/watch?v=aTFpN0LJN0c as a reference, hope this helps..

Cheers,

PMDY

Was this reply helpful? Yes No