Working with multi-select fields in Get items output Getting 3 Rows for Record instead of 1

[tobor58]

Chad - Thanks for hearing me out  please let me no if the screenshots are viewable. 
The Data - SharePoint List

The Results: 

The Flow

[ChadVKealey]

In the "SelectToCreateTheRows" action, change the input (value) to "current item" (or just use the "item()" expression, which is the same thing). Because there are three values, I think it's processing all three SP list items on each iteration of the loop. Just a hunch, though.

[tobor58 · Accepted solution]

Chad, 
Spot on with a caveat 
Current Item (Dynamic Content) or Item() expression alone will fail with 

BadRequest. The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array.

I know that I had tried to use Current Item several times but never attempting CONVERTING it. 
It wasn't intuitive to me that I would need to actually convert it  vs. just use what was in the box  as-is. 

Wrapping it into an expression to convert it to an array makes it work like it should. 

Using this for an input on  SelectToCreateTheRows" action, 

 array(items('EachPlatformOnRow'))

Thanks!

[J-lee]

@tobor58 @ChadVKealey .  This is the exact issue I am having and you are the only ones I have seen with a solution.  I am having a little trouble replicating the solution.  Could you provide screenshots of the flow AFTER you made the change and provide a little more detail since I'm less experienced?  Also, could you provide the screenshots of the flow in two images (or 3) so it is a little easier to read? That would be amazing! THANKS

[ChadVKealey]

It might be easier if you share what your flow looks like (maybe in a separate post, even if it's the same kind of issue) along with a clear description of the issue you're facing. In particular, it's important to know what kind of field you're getting data from (text, single select choice, multi-select choice, etc.) and what you want to do with that information.

[J-lee]

@ChadVKealey Thanks!  I will work on writing that up and will make it a separate post.  I've found your video very helpful.  That's where I started with this solution, but then got the 4 rows instead of one issue.

[J-lee]

@ChadVKealey Posted:  Multiple choice columns in SharePoint library – Output has the Multi-choice data all on one row instead of multiple rows