Hello
I have created a flow to generate an excel file within SharePoint using data from Dynamics.
To format the data, I have used a select step to map the fields for the file to use:
In the output of the final step of the flow, I can see the data for these fields are written to the file as USD.
The problem I have is within the excel file, the columns using these fields are displaying in only GBP, I have tried formatting the template file columns to currency however this does not resolve the issue.
Has anyone experienced this? Ideally I would like the exported file to display the raw values from the flow output step as this will be used in a report.