Unanswered

Filter array issue

(1) Share

Report

Posted on by CU13081336-0

I have an action to filter a sharepoint list using the filter array action. I want the filter criteria to be the output from a compose action in the step before. However when i test the flow the filter array is just returning blank. To check the issue I copied the output from the compose action and pasted this as a hard coded value in the filter array rather than as dynamic content and the filter then worked. Any ideas why the filter works when using the compose output but not using the compose output dynamic value?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Could be related to the type of data. What is the value you are testing with, it is it a number?

Can you share a screenshot of your flow setup as well? This would help troubleshooting.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

Please use pictures, not words.

Annotate pictures, show us a Run, show the Inputs and Outputs.

We are good not magical :-) share share share

Was this reply helpful? Yes No
CU13081336-0 6 on at

Like (0)

Report
Copy link

Link copied!

Apologies, this is my first time using this forum.

The data type being used is an email address so not numbers etc. just FirstName.LastName@company.com. I also used the string function to ensure the emails in the dynamic content were captured as strings in the filter which also did not work.

The outputs of the Emails step show the correct emails that I want to filter by (covered some of the emails for privacy reasons) :

The filter query with dynamic content does not work. However when i copy the output from the compose step and hard code it into the filter query the filter works.

If you need any extra details I am happy to provide them! Thank you for your assistance

Was this reply helpful? Yes No
abc 123 789 Moderator on at

Like (0)

Report
Copy link

Link copied!

Ensure what the format of the AssignedTo0.Email looks like. It probably won't be as simple as "Bob.White@domain.net". It'll probably have special characters, claims, and other junk that you'll have to figure out how to navigate around.

For debugging, I write things to a variable, such that I can see what it's assigned, prior to sticking it into the impossible-to-debug Actions like "Filter Array". (I don't know why Microsoft hates developers so much nowadays.)

In all of my Flows, I initialize a variable called strCodeComment, and I use it to write out values, take notes, etc, such that when debugging, I can see stuff at a glance within the Run instance.

Was this reply helpful? Yes No
CU13081336-0 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the suggestion GDSI!

However I think the problem lies with the apply to each item dynamic content rather than the assigned to email. I have wrote assigned to email into a varibakle and it only contains email: first.last@company.com.

As well as when i just hard code the apply to each current item output into the filter array the filter works so I assume that the assigned email is not the issue here.

Was this reply helpful? Yes No