Hi Experts,
How can I use NPV function directly in power automate. it does exists in Excel. However my goal is the create it within power automate flow (maybe in compose action) and perform the calculation based on the NPV formula.
Thank you
Hi Experts,
How can I use NPV function directly in power automate. it does exists in Excel. However my goal is the create it within power automate flow (maybe in compose action) and perform the calculation based on the NPV formula.
Thank you
@Anonymous as far as i know Power Automate does not have expressions for NPV, SharePoint and Excel supports it, so you can have SharePoint or Excel do the calculation and fetch value from excel or SharePoint in the Power Automate as alternate solution.
WarrenBelz
146,668
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional