I am using the Get File Content to grab the contents of a CSV file, however the output of the get file content is
Solved! Go to Solution.
I am dealing with the same issue, and trying to find a solution that does not require a third party connector like Encodian, as it is not an option for me.
Here is a solution for you, this works for me all the time.
Have you tried to change the option Infer Content Type to Yes (default is No)?
See the difference in my flow below.
Infer Content Typs = No
Infer Content Type = Yes
Let me know if you need more help with the following steps to extract the CSV data.
Mark as solved if it did answer your question.
My experience is that it has generally been marked Yes by default. But it did not make a difference.
Though, having it on did prevent my flow from being able to read in and parse the content of a JSON file. In that case, I had to set it to "No".
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!