Unanswered

Select Functio

(0) Share

Report

Posted on by werdnak

Hi all,
I am new to Power Automate and thought if someone could give me a pointer.

I am using the following to create a CSV table but it is returning an additional 24 rows. I figure it is because the Output of Select 2 have 24 elements (or question), so they are replicating the entire table 24 times.

How do I prevent this? Thanks .

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

Hi!

Select transforms elements from an array, keeping same nr of elements from the input. So, the 24 rows are due to the array currently assigned as input to your Select action block.

Are all rows duplicates? Do you need just one row?

Can you provide more details from your Flow design by means of a more detailed screenshot?

Thanx!

Was this reply helpful? Yes No
werdnak 56 on at

Like (0)

Report

hi @efialttes ,
Thanks for your guidance.
To begin, I have a Microsoft Form with 19 questions. I created an MS Flow as following:
Compose - body('Get_response_details')
Compose 2 - string(outputs('Compose'))
Compose 3 - split(outputs('Compose_2'),',')
Select2 - outputs('Compose_3')
Create CSV Table - body('Select2')

The outputs are as follow in a CSV File:

Was this reply helpful? Yes No
werdnak 56 on at

Like (0)

Report

@efialttes

I really just want to see one row like this:

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (1)

Report

Hi!

I believe you are mappint your Select values directly from 'Get response details' dynamic content right?

If so, you just need to assign a dummy array as 'Select' input, make sure the array has a single element inside. For example:

There are more elegant ways to achieve this but this should make the trick

Hope this helps

Was this reply helpful? Yes No
werdnak 56 on at

Like (0)

Report

Thanks @efialttes - This works. I overcomplicated the formula 🙂

Was this reply helpful? Yes No