Select Functio

Like (0) Share

Report

Posted on 9 Jul 2020 03:08:33 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 .

All responses (5)

Answers (1)

werdnak 56 on 09 Jul 2020 at 07:31:23

Like (0)

Report

Re: Select Functio

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

efialttes 14,756 on 09 Jul 2020 at 07:24:21

Like (1)

Report

Re: Select Functio

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
werdnak 56 on 09 Jul 2020 at 06:56:10

Like (0)

Report

Re: Select Functio

@efialttes

I really just want to see one row like this:
werdnak 56 on 09 Jul 2020 at 06:54:43

Like (0)

Report

Re: Select Functio

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:
efialttes 14,756 on 09 Jul 2020 at 06:41:25

Like (0)

Report

Re: Select Functio

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!