cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AJ13
Level: Powered On

Server Response: The Expression is invalid

Hi,

 

I am trying to pull in more than 2000 records into a collection based on posts I could find.

UpdateContext({firstrecord: First('Logical Access')});
UpdateContext({lastrecord: First(Sort('Logical Access',ItemID,Descending))});
UpdateContext({maxiter: RoundUp((lastrecord.ItemID-firstrecord.ItemID)/500,0)});
ClearCollect(iter,AddColumns(AddColumns(Filter(Num,Nmbr<=maxiter),"min",(Nmbr-1)*500),"max",Nmbr*500));
Clear(Temp_Coll);
ForAll(iter,
	Collect(Temp_Coll,Filter('Logical Access',ItemID >= firstrecord.ItemID + min && ItemID < firstrecord.ItemID + max)
	)
)

ItemID is a Numberic column in my SP list with unique numbers.

 

I am getting the error:

 

Server Response: The expression "(ItemID ge (84 add 0))and(ItemID lt (84 add 500))" is not valid. 

Please help. Thanks in advance.

 

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,203)