News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion How to avoid filter ar...

Power Automate - General Discussion

Unanswered

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

(1) Share

Report

Report

Posted on by CU20080932-1

99

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

All responses Img

All responses (2)

Answers Img

Answers (0)

G0Springs 134 on at

Like (0)

Report

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

I would also like to know how to avoid the filter array record limit
CU20080932-1 99 on at

Like (1)

Report

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

@ScottShearer @Expiscornovus please help me guys

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

Leaderboard > Power Automate - General Discussion

#1

stampcoin 23

#2

Pstork1 20 Most Valuable Professional

#3

Gprior 19

Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans