Power Automate - Using Flows

Unanswered

Error Message - Too many bytes when filtering array

(0) Share

Report

Posted on by AH-02011058-0

I have a RequestArray and ResponseArray. For each request there are about 20 responses.

In Power Automate I want to go through each request and find the responses relating to it. I get this error message.

The action 'Filter_RTBFResponsesArray_for_Validation_Teams' was executed for '291' iterations resulting in an aggregated result size that exceeded the maximum value '209715200' bytes allowed. Please reduce the number of iterations to ensure that the aggregated results size is less than '209715200' bytes.

The filter condition for the responses array says

@and(
equals(item()?['RequestID'], items('Add_up_the_Total_Time_From_Team1_to_Team2')?['ID']),
equals(item()?['TeamType'],'Team I want'))

I've tried reducing the number of columns in both arrays.

What's the best way to deal with this error message?

Categories:

Flow Mobile App

I have the same question (0)

All responses (4)

Answers (0)

Pstork1 68,362 Most Valuable Professional on at

Like (0)

Report

Error Message - Too many bytes when filtering array

I would try breaking it out into two Filter arrays to simplify the filtering required. First filter on one of the conditions

equals(item()?['RequestID'], items('Add_up_the_Total_Time_From_Team1_to_Team2')?['ID'])

Then filter the results of that on the other condition. Since its an And condition the result should be the same, but doing it seperately will simplify the processing logic which may solve the problem.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
AH-02011058-0 on at

Like (0)

Report

Error Message - Too many bytes when filtering array

Thanks.

Is there a better way of splitting the request than using multiple conditions. I don't really want to divide 293 rows into groups of 20.

How can I see the size of the array generated, so I can increase the interval from 20?

Is there a way to use a Switch instead of nested conditions?

Was this reply helpful? Yes No
Pstork1 68,362 Most Valuable Professional on at

Like (0)

Report

Error Message - Too many bytes when filtering array

Can you explain what you are trying to accomplish? Is it just to get one array that contains all the requests lined up with the responses? The final goal will dictate what the procedure is.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
AH-02011058-0 50 on at

Like (0)

Report

Error Message - Too many bytes when filtering array

The request array has various dates for the whole request eg when it was received, when it was handed over to the teams and when it was completed.

The Responses array has the response from the individual teams who are meant to deal with the request.

I want to compare those dates.

I think the best way to do this is to have one array that contains all the requests lined up with the responses

One idea I've had is to do a Select statement to add a column to the RequestsArray. It inserts a random number between 1 and 5. I can divide the block into 4 using a Switch statement on the value of the new column. This assumes that the random function will give me a similar number of each value.

If you have a better idea, please let me know.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Error Message - Too many bytes when filtering array

Helpful resources

News and Announcements

Quick Links

Coming soon: forum hierarchy changes

Chiara Carbone – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Error Message - Too many bytes when filtering array

Helpful resources

News and Announcements

Quick Links

Coming soon: forum hierarchy changes

Chiara Carbone – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates