Empty output after filtering array

(0) Share

Report

Posted on by HG-08061736-0

I am struggling to get an output from my filter array on taxID step. I've tried looking at solutions, and while I have implemented them, nothing has worked. I want to eventually merge/combine these two arrays into one array to eventually be pushed into a db table, but I need to get the SourceSystemID where the taxID from subcontractor array equals the taxID from prequal array first.

where TaxID = item()?['TaxID']

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @HG-08061736-0,

are you sure both TaxID values (Subcontractor and Prequal) are same If yes, ask both fields have similar kind of data and both field type is string, correct?

Please try something like this:

@equals( trim(string(item()?['TaxID'])), trim(string(items('Apply_to_each_2')?['Prequal']?['TaxID'])) )

If this helped resolve your issue, please click “Does this answer your question?” so the solution is marked and easier for others to find.

Was this reply helpful? Yes No
HG-08061736-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

This is my first power automate, and I come from a programming background. I'm trying to loop over the prequal array (the apply to each) and compare the TaxID value to the TaxID values which are in the subcontractor array.

I tried your suggestion, and while I think it is actually helpful (there is a hyphen in TaxID so converting to string is probably a good idea), I still get no output. Maybe I am misunderstanding how apply to each works

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@HG-08061736-0,

Got it, there is no any issue both place TaxID is different that's why it's not matching and giving any output.

Could you please send the both TaxID? That will help us to suggest the approach.

If this helped resolve your issue, please click “Does this answer your question?” so the solution is marked and easier for others to find.

Was this reply helpful? Yes No