Answered

Need help with flow

(0) Share

Report

Posted on by rpitts

I have a flow where in an Apply to each, the output from previous steps is a variable array. (Screenshot 1). The next step in the apply to each section is a Filter Array where the from is Value from Get Items from a sharepoint list. (Screenshot2) My filter is @equals(item()?['ID'], items('Apply_to_each_varFinal')?['AssignedAttorney']). I then use an Append to array to get results from the apply to each. However, even though I can see that the filter should be working, I'm not getting anything in the body of my append to filter array (Screenshot 3). Any help as to why this is not working would be greatly appreciated.

Screenshot 1

Screenshot 2

Screenshot 3

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Need help with flow

Hey @rpitts

This is happening because your ID is of type integer/number, and your AssignedAttorney is of type string.
Now in your filter array, you will have to convert either ID to a string type or AssignedAttorney to a integer type.

So, try one of the following expressions in your filter array:

@equals(string(item()?['ID']), items('Apply_to_each_varFinal')?['AssignedAttorney'])

@equals(item()?['ID'], int(items('Apply_to_each_varFinal')?['AssignedAttorney']))

I hope atleast one of them works for you 🙂

Was this reply helpful? Yes No
rpitts 61 on at

Like (0)

Report

Re: Need help with flow

Thanks Sundeep. Very much appreciate the response. Unfortunately, I don't believe that's the issue. The "AssignedAttorney" is already an integer, unless the action of adding it to the variable array (varStaging) is converting it from int to string. Originally, it is the id of a lookup field "first(body('Filter_array'))?['AssignedAttorney/Id']". That is what is being added to varStaging as "AssignedAttorney." That said, I'm up for trying anything so I tried to convert to int and received this error: "The execution of template action 'Filter_array_Final' failed: The evaluation of 'query' action 'where' expression '@equals(item()?['ID'], int(items('Apply_to_each_varFinal')?['AssignedAttorney']))' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'." Any other ideas? It's so frustrating.

Was this reply helpful? Yes No
Verified answer

Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Need help with flow

@rpitts

Yup I think when you are adding it varStaging it's converting it to a string type, not exactly sure why it's happening, probably because it's a lookup.

If you see it in your screenshot correctly, the AssignedAttorney has double quotes, which totally shows that it's being converted to string somehow.
And when you are trying to match it with the Id, it's giving an error as both are not matching because of different data types.
I gave you two expressions above, try the one with string. If that also doesn't work, I will try to think of any other method.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

Re: Need help with flow

@rpitts
Try one more thing, outside the apply to each initialize an integer variable.
Inside the apply to each use set variable pass the AssignedAttorney in it. After this pass this variable in the filter array. Probably this should work.

Was this reply helpful? Yes No
rpitts 61 on at

Like (1)

Report

Re: Need help with flow

It was total user error. As it usually is. And now that I see it I feel so !!! . You turned me in the right direction by pointing out the quotes. When I was running append to array, for the value I was designating it specifically and I had the ID object in quotes!!!! so it was explicitly converting that to string which caused the bad result when using that variable downstream. Thank you again for spending time on this. I really appreciate it.

Was this reply helpful? Yes No