Answered

Filtering an Array created from a Compose Split Action

(0) Share

Report

Posted on by cjbaguley

Hi Folks,

Not sure what I'm doing wrong, I have a flow that rips the body out of an email to pull relevant information ready to drop into a SharePoint list.

I have the basics mapped out and working as intended, however I am trying to elevate it slightly and remove the last bit of irrelevant guff.

I have a compose action that results in the following output:

I now want to filter that array to only have the rows starting with '[' (The two "Medium" rows displayed above.

I have tried Filter Array using item()?['Value'] as the Filter Query, with many variations thereof, however I keep getting an error message that "Value" can't be selected for type String.

I also tried initializing a variable and setting it with the compose action output, with similar result.

I have tried searching the forums and wider with variations on this, with limited success, so I'm wondering if this is even possible. It seems like the compose output array is not being treated as an actual array.

Any help will be greatly appreciated.

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (1)

Power Platform 1919 1,512 on at

Like (0)

Report

Filtering an Array created from a Compose Split Action

Hi @cjbaguley,
I think it is doable , we can filter the array,

can you please share the inputs and outputs (raw outputs) of the compose action . just to be sure , can you share the power automate expression used,
it can be helpful , when giving solution

you can check this article :
Extract information from an email with Power Automate

Was this reply helpful? Yes No
Verified answer

DeveloperAK 88 on at

Like (2)

Report
Filtering an Array created from a Compose Split Action

Hello @cjbaguley

It looks like the issue is simply that the output from your Compose isn’t an array of objects – it’s an array of strings.

Because of that, Power Automate won’t let you use expressions like item()?['Value'], since each item is already just a string and doesn’t contain any properties.

How to filter only the rows starting with "[".

In your Filter array action:

From:

outputs('Compose') (or whatever your compose step is called)

Condition:

Use an expression:

startsWith(item(), '[')
item() returns the current string in the array, so startsWith() works directly on it.

📩 Need more help? Mention @DeveloperAK anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping

1 people found this reply helpful.

Was this reply helpful? Yes No
cjbaguley 35 on at

Like (1)

Report

Filtering an Array created from a Compose Split Action

Perfect!!

Thank you so much for the detailed reply, it really helped me understand the different types of arrays.

When I put the expression item() into the filter query field, it initially formatted it as "Email Attachment Item", but then on saving and running, changed it to "Current Item" as below, this was the final "aha" moment for my brain to get around it:

Giving me the result I needed:

Thanks again for sharing your knowledge and expertise!!!

Was this reply helpful? Yes No