Requirement: Power Automate create a CSV table and then create a CSV file using Power Automate.
Use the SharePoint list called EmployeeDetails list. Use this list to create a CSV file.
Power Automate create CSV table csv file
In Power Automate, select the Manually triggered Flow, then click on the Next step
How power automate create CSV table CSV file
Select, Get items action, then provide site address, List name, and Top count as 100.
Microsoft Flow create csv table csv file
Now create a CSV table with the custom columns, so click on the next step and select Create CSV table action, then in From field select the value from dynamic content. And select column as custom, then map the custom header with SharePoint column value.
MS Flow create csv table csv file
Now create a CSV file in the SharePoint library, so click on the Next step and select Create File action. Then Provide the site address, folder path, file name, and in the file content add the output from the dynamic content.
How MS Flow create csv table csv file
Now click on Save and run the Flow manually, and see a file created in the SharePoint library.
Microsoft Flow create csv table csv file
And open this CSV file, see the data have been created.
How to create csv table custom column using Microsoft Flow