Hello, I have a flow that takes a file from Sharepoint and retrieves only certain columns from that file. It then, needs to create a new csv file that includes only the columns I selected. Everything works properly, except for the file creation part. It looks like this:
The CSVDecode variable is an array and it uses the following formula:
Then, the Select action uses the output of the CSVDecode variable to retrieve the corresponding columns from the file skipping headers:
Finally, the Create file (which should not be a loop, as I only want one file to be created, takes the body from the Select action
And creates the file using the outputs of the Select action.
I have two problems:
1. Instead of creating a single file, Power automate automatically creates a loop when I add the Create file action, therefore, it creates one file per each one of the items in the file.
2. The information is not pulled correctly in the file. Instead of showing the information as shown in the outputs, it is blank in each one of the files as shown below:
This is the output of the Select action:
Any help would be greatly appreciated.
