Power Platform Community Forum Thread Details

Hello everyone, basically I want to loop through a sharepoint folder with csv files, and if the file name contains a keyword, pick that file and count the number of rows in the file. Is there an easy way to do this? I cant find much online, thanks!

Categories:

General topics

Hi,

is your problem to loop through the SharePoint list or through the file?

To loop through the list you do the following steps:

1. Create an action "Get files (properties only)" from the SharePoint Connector

2. Create a "Apply to each" loop.

3. Add the "body/value" attribute from the "Get files" action to the input of the loop.

If you want to count the number of rows in a csv file. This is not trivial, but you could try the following.

1. Create an action "Get file content" form the SharePoitn connector.

2. Create a "Compose" action with the following expression "split(body('Get_file_content'),decodeUriComponent('%0A'))". This splits the content of the file at every new line.

3. Create another "Compose" action with the following expression "length(outputs('Compose'))". This counts the number of items in the array created by the action before.

The number of rows in the CSV file should be in the last compose action.

Regards

-----------------------------------

If my answer solved your issue, please mark it as a solution.

If what I wrote helped you, please give it a thumbs up.