I am using a custom AI model to parse fields from an invoice. In my SharePoint list I have the "Total Amount Due" as a number as it should be. My challenge is sometimes the AI grabs just the amount while other times it grabs the $ in front of the amount. I assigned the value parsed from the PDF for "Total Amount Due" to a variable TotalAmountDue. I then add a "Compose" and use the function:
replace([variables('TotalAmountDue')], '$', '')
It keeps telling me this is an invalid function yet the documentation on "Replace" shows:
replace([columnname], '$', '')
I have seen others having similar issues but they are using a capital Replace or double quotes. I'm not making any of these mistakes.
What am I doing wrong?
Solved! Go to Solution.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.