Answered

Create csv file in sharepoint using Power Automate

(0) Share

Report

Posted on by DPJAY

Hi,

I am trying to create a flow using Power Automate and the expected functionality is to read an excel file stored in share point and export it to csv file in the same share point location. The challenge I am facing is when I use custom columns option to keep just those fields that I require in my final csv output file. I am getting different fields in csv compared to the fields that I have kept in create csv table step.

Categories:

Business Process Flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Ellis Karim 11,465 Super User 2025 Season 2 on at

Like (1)

Report

Re: Create csv file in sharepoint using Power Automate

You could read the Excel file, then use the Select action to select the desired columns. You need to ensure that the column names used the Select action match the column names in the Excel. For example:

This is the file that the Create CSV table action produced, the column names match exactly the Excel file.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
DPJAY 18 on at

Like (0)

Report

Re: Create csv file in sharepoint using Power Automate

@ekarim2020 Thanks a lot ...I am able to get the file now. Can you also help me with your thoughts on the below

1. Keep the date format in the same way we have in source file...in my case I have to keep it in MM/DD/YYYY format for the next steps to be executed in Power Automate Desktop
2. Is it possible to save the file as .xlsx using this create csv table step or is there any other flow action that will help me to save it in .xlsx format.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,465 Super User 2025 Season 2 on at

Like (1)

Report
Re: Create csv file in sharepoint using Power Automate

@DPJAY wrote:
@ekarim2020 Thanks a lot ...I am able to get the file now. Can you also help me with your thoughts on the below

1. Keep the date format in the same way we have in source file...in my case I have to keep it in MM/DD/YYYY format for the next steps to be executed in Power Automate Desktop
2. Is it possible to save the file as .xlsx using this create csv table step or is there any other flow action that will help me to save it in .xlsx format.
1. I haven't worked with Power Automate Desktop.
You can format the date in the Select action using the formatDateTime() function.
Note the StartDate and EndDate format above.

formatDateTime(item()['StartDate'],'MM/dd/yyyy')

When using the List rows actions, ensure that the Date Time Format is set as ISO 8601:

(2) To save the data as a new Excel file - this requires more effort.
Here are some options:
How to export data in Power Automate to an Excel File (tachytelic.net)
Convert CSV files to Excel workbooks - Office Scripts | Microsoft Docs

Ellis

Was this reply helpful? Yes No
DPJAY 18 on at

Like (0)

Report

Re: Create csv file in sharepoint using Power Automate

@ekarim2020 Thanks for all the help...one last question...is it possible to use a parameter passed from Power Apps in that Select step. I am able to see Ask in Power Apps option but when I click it nothing gets added to map the field corresponding to custom fields that I create in Select step. The trigger for my flow is from Power Apps and I am trying to add few more fields in addition to what I have in my excel file to create final CSV output

Was this reply helpful? Yes No