delete excel rows while no table

[mengyu202]

Hi everyone, I need help with deleting rows from excel with no table, to be more precise, it's deleting rows from a .csv file, not .xlsx, but hope the two file type can share a similar code

here's my full process:

a different team will save a daily report in csv format in folder A; then I have the power automate to grab the most update file every day at 8am, copy the file content to my folder B with 'update file function'. But I actually only need the first 30 rows of that daily report, is that a way to only copy the first 30 rows, or after copy delete rows (clear content) after row 31? There's no table in the file so I can't use 'list row in a table', and I can't create a table because the report is generated and saved by a different team.

[SudeepGhatakNZ]

 @mengyu202 ,CSV file is simply a text file.

So you can use the split function with a newline delimiter to split in into multiple objects in an array.

split(outputs('Get_file_content_using_path')?['body'], decodeUriComponent('%0A'))

Then simply select the top 30 items in your array

[AlexEncodian]

@mengyu202 
  

For a simple no code 1 step solution that works for both CSV and Excel files with no tables, Encodian's Delete Rows from Excel action will do this job.

You can configure from where it starts deleting rows.

----

Encodian is a Standard Power Automate connector with 150+ actions to supercharge your flow builds including document conversion, merging, splitting, data manipulation, search, extraction, OCR and much more.

[mengyu202]

Thanks. It's first time I used Encodian and it asks me for a connection name and API key, how can I find that? Is this an extra account/license I need to have?

[mengyu202]

I need more help on this, can you please tell me what action I should use for this split and how to select the top 30? Thanks.

[SudeepGhatakNZ]

Here you go:

Sample 

Flow:

Flow History:

[mengyu202]

This is the error message I got.

If I change the split function to split(string(get file content),compose-newline), it only shows the first row in excel, but if I open the file in notepad, it show first 30 rows. Any idea why would this happen and how to fix this?

Thanks!

[SudeepGhatakNZ]

Please refer to the attached sample.

[mengyu202]

I have the same error as before - the only different between your attached sample and mine is that I use SharePoint get file content instead of OneDrive.

[SudeepGhatakNZ]

Let me check with SharePoint datasource

[SudeepGhatakNZ]

SharePoint gets the contents of the file using Get File Content action in Power Automate as a Base64 Encoded string.

So just tweaked the flow a bit.

[mengyu202]

I still get the same error:

Unable to process template language expressions in action 'Compose-ToString' inputs at line '0' and column '0': 'The template language function 'base64ToString' expects its parameter to be a string. The provided value is of type 'Object'.

[SudeepGhatakNZ]

Can you post the screenshot of the Get File Content action and the compose action under it?

[mengyu202]

Here's my full flow, and the error is in the base64tostring step.

[SudeepGhatakNZ]

I want to see the output of the Get File Content action and the expression in your compose action under it.

[mengyu202]

I hope I am giving you the right thing. 

Output of Get File Content:

and below are all content that making no sense to me

this is the error step

Compose-NewLine is as you suggested, just enter

[SudeepGhatakNZ]

Base 64 expression is incorrect. You are missing $content. Sorry the last screenshot was not clear.

[mengyu202]

It's the same as using string() formula, while opening the output csv file with notepad, it has many unformatted data: 

but open the file with excel only has one row: