web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Create CSV Table gener...

Power Automate

Answered

Create CSV Table generates duplicate rows

(0) Share

Report

Report

Posted on by rwittels

510

Hi. I created a simple flow to split a filename into an array and then output that array into a CSV Table. My issue is that the CSV Table appears to be creating a duplicate row for each index of my array.

var FileName string = "123456_Document Type_18_08_2023_16h34m"

The array is created correctly as the apply to each splits the file name at each "_".

I am using stringArray as the input for the CSV table and each value as an index of it:

What am I doing wrong?

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @rwittels ,

Here is a method for your reference:

Compose:

split('123456_Document Type_18_08_2023_16h34m','_')

Array:

outputs('Compose')[0] outputs('Compose')[1] concat(outputs('Compose')[2],'/',outputs('Compose')[3],'/',outputs('Compose')[4]) outputs('Compose')[5]

The result of my test:

Best regards,

Rimmon
rwittels 510 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. I didn't know that I could access index values from a compose block.

Join the conversation