cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yallaling
Helper II
Helper II

How to avoid filter array record limit, may be filter array filter only 1000 record

The expression to check the values in the Product and brand columns:

@and(equals(triggerBody()['text'], item()?['Product']), equals(triggerBody()['text_1'], item()?['brand']))

 

The expression to retrieve the values of the life cycle and DNE columns of the first item of the filter array.

concat(first(body('Filter_Array'))['life cycle'], ', ', first(body('Filter_Array'))['DNE'])

 

I am using above expression to filter data, but its working only for only 1000 record. Please help me guys 

 

Yallaling_0-1650289810461.png

 

 

2 REPLIES 2
Yallaling
Helper II
Helper II

@ScottShearer @Expiscornovus  please help me guys 

I would also like to know how to avoid the filter array record limit

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,197)