cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarcoS Helper I
Helper I

Duplicated rows in created CSV file

Hi All,

 

We've build a Flow that extracts data from the database and creates a CSV file on a SFTP server with that data. The strange thing is that it duplicates some rows in the CSV file. It looks random. The rows are not duplicated in the database so the problem is in Flow. Does anybody know why it is doing that?

 

Thanks.

 

Marco

4 REPLIES 4
Dual Super User
Dual Super User

Re: Duplicated rows in created CSV file

Hi @MarcoS 

 

Can you please share a screenshot of the flow? Can you confirm that you do not have any altrenate flows running that might be creating these duplicate records? 

 

 

MarcoS Helper I
Helper I

Re: Duplicated rows in created CSV file

Hi,

 

No nothing is running at that moment.

 

2019-08-22 13_27_47-Run History _ Microsoft Flow.png

Dual Super User
Dual Super User

Re: Duplicated rows in created CSV file

Hey @MarcoS 

 

A bit difficult to undersatnd the actions and the notations on the language that you are using. It will be really helpful if you could translate those to English.

MarcoS Helper I
Helper I

Re: Duplicated rows in created CSV file

Hi,

 

In order:

 

1. Run the view V_CS_FLOW_EXT_ACE_FTR with the oracle connector

2. Create a CSV table from this view

3. Run the view V_CS_FLOW_JAAR_VW so that we have the actual Year and Week of today

4. Select the results from this view so that we can use it in your file name

5. Create filename

6. Write CSV file to SFTP

7. Email

8. Write another CSV to another SFTP

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (5,935)