Power Platform Community Forum Thread Details

Running into a weird problem I can't figure out. Each day I have a CSV Report that is emailed from Salesforce. I have a PowerAutomate flow that parses it, and imports it into a list. The 3rd column is a date, ie 01/12/2024.. When the flow runs, it is putting /r on the end of the date (it's the last column). I have this to remove it:

replace(outputs('splitByComma')?[3], '\\r', '')

Now, the weird part is that if I log into Salesforce, export the same report as a CSV File and download it, Send myself an email with it as an attachment the flow runs, and imports it correctly.. I am not making any edits to the CSV file, or even opening it. I am not sure why it's not importing it correctly if it's emailed from Salesforce, but is when I export it and email it to myself.

Categories:

General topics