
Announcements
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.