Is someone able to kindly help with a workaround to format array values?
I've developed a flow to create a purchase order. The unit price and the item line total need to be formatted to currency.
Please see the screenshot of the flow.
The data is coming from SharePoint but it comes as a string. I've attempted to convert it into a float via Compose (which is displaying the correct result) but I can't get the correct result into the array, it doesn't accept the output and I've tried various things.
The formula of my Compose input is; formatnumber(float(items('Apply_to_each_3')['OrderLineTotal']),'$#,##0.00')


Report
All responses (
Answers (