Answered

CSV Export remove blanks

(0) Share

Report

Posted on by Community Power Pla...

Howdy everyone! I have browsed around here to find a solution and I have found a few that kind of do what I need but they're not exactly working for me.

My intent is to take a table from an excel file and export it as a CSV so that the data can be imported into our ERP system. However when I try to import the file it errors out because there are blank values in the exported CSV. This flow works great until it gets to the filter connection of the flow.

My hope was to add a filter to my current CSV export Flow to prevent any blanks from being added to the CSV but it keeps timing out. This is what I currently have:

Any help that yall could provide would be amazing, thanks!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous :

Do you want to filter out items whose value in a certain field is empty?

If so,just need to add a condition to the condition:

Fill in the field you want to filter in the blue circle I marked.

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks Bof for your suggestion, I tried that but get an 'get_file_content' failed error (see below):

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Hello @Anonymous ,
I think you could filter the empty rows already in the 'List rows present in a table' action by adding a 'Filter Query' to filter only rows where some column is not empty (column is not equal to ''). That will give you only the not-empty rows and you can store all of them in the .csv file.
Column ne ''

To your current solution, the flow you currently have will not behave as you expect (I suppose). You're using 'Apply to each' on each of the rows, and then based on condition you create a .csv file. That means that if you have e.g. 20 rows in the table, the flow would do all the actions inside 'Apply to each' 20 times, and create a .csv file each time a row is not empty, e.g. with 20 rows, 2 of them are empty, the flow would create 18 .csv files (and I'm not sure if you even filter the empty rows from the result when creating the .csv).

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thank you! i was unaware of the filter on the "list tables" connector and after googling the documentation on it, I was able to get to successfully work!

Was this reply helpful? Yes No