Unanswered

Converting csv file to txt using Power Automate

(0) Share

Report

Posted on by RL3

Hey everyone,

I need to build a Power Automate Flow that takes a csv file that was uploaded to a shared drive in Sharepoint, converts it to a txt file and sends it as an attachment in an email.

I've tried several strategies to achieve this but I can't get the correct content, it's always outputting a txt file with just one line of random numbers and letters, not what is on the csv file.

Is there a simple way to do this?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Alex_Rackwitz 9 on at

Like (0)

Report

@RL3

Encodian's Convert Excel can convert CSV (as well as many other formats) to TXT.

Was this reply helpful? Yes No
RL3 6 on at

Like (0)

Report

Hey,
I have implemented your suggestion but it seems like my problem is coming up before I get to that step, I've tried several inputs as the file identifier and they are all giving me an error when I get to the get file content step, it always says the file id is not valid, do you know what could be causing this?

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on at

Like (0)

Report

@RL3

you’re using a SharePoint trigger and a OneDrive get file contents action. Use the SharePoint get file contents action

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (1)

Report
You can achieve this fairly easily using standard connectors (no need for a third-party solution).

See full flow below. I'll go into each of the actions.

When a file is created (properties only) will trigger when a file is uploaded into the specified folder. Note that you should use this trigger as appose to yours which is now depreciated.

Get file content retrieves the content from the file using the Identifier.

Send an email uses the Name of the file followed by .txt and the following expression to convert the content from base64 to text.

base64ToString(outputs('Get_file_content')?['body']?['$content'])

Was this reply helpful? Yes No
RL3 6 on at

Like (0)

Report

I was using that previously and it wasn't working, then I saw in the outputs of the get file content action that it seemed it was retrieving the wrong content, that is why I attempted a different approach

Was this reply helpful? Yes No
RL3 6 on at

Like (0)

Report

I had tried this before and it didn't work, but I tried it again because I could be making a mistake in the attachment content part. However, this is what I'm getting now, do you have any idea how I can fix it?

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on at

Like (0)

Report

@RL3

Just a tip to help people help you. You need to paste your flows, with actions expanded, so that we can see what you have done. See how Grant showed you what his flow looks like

Was this reply helpful? Yes No