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

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

@leyburn19  Mine error appears with 2 records in SP List. So I could bet my soul that is have nothing to do with delegation issues. 

dhock
Level: Powered On

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

@leyburn19 , my limit is still set to 500 (never increased) and I'm getting the error.

Jswanson
Level: Powered On

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

Same Error here on multiple apps. It seems to happen on ClearCollect more often then not.

dhock
Level: Powered On

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

@v-xida-msft , thanks for your reply. I have 3 galleries with filters but they are all similar, just using a different SharePoint list as a datasource. They look like this:

 

FirstN(Sort(Filter('Ma3an Meeting Minutes', Lower('Created By'.Email) = Lower(User().Email) && !('Approval Status'.Value = "Approved")), Created,Descending), 50)

 

I did try creating a collection for one of them, but I used the same filter on the list to create the collection and then set the gallery Items property to the collection. I still got the error after that. I don't currently have more than 500 items in any one list but I anticipate that I will at some point. Interestingly, though all 3 galleries use essentially the same filter, only accessing 2 of the related forms give the error (whether by selecting an item in the galleries or using a button that goes to a form with no item selected, i.e., newform of list).

 

Thank you also for the link to create a ticket.

Jswanson
Level: Powered On

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

This is a runtime error as well

Here is a copy of my OnVisible

ClearCollect(_DataCounts,
{ID:4,DC:CountIf(col_ActiveParcels,_FileNumber = 'Own.FileNumber')},
{ID:5,DC:CountIf(Parcel_LandUse,_FileNumber = 'LandUse.FileNumber')},
{ID:6,DC:CountIf(Parcel_Utilities,_FileNumber = 'Util.FileNumber')},
{ID:7,DC:CountIf(Parcel_Zoning,_FileNumber = 'Zoning.FileNumber')},
{ID:8,DC:CountIf(File_Notes,_FileNumber = NoteFileNumber)},
{ID:9,DC:CountIf(File_Attachments,_FileNumber = AttachFileNumber)},
{ID:11,DC:CountIf(Parcel_Improvements,_FileNumber = ImprovementFileNumber)});
Concurrent(
ClearCollect(
col_ActiveFile,
First(Filter(col_LandFiles,'File.FileNumber' = _FileNumber))),
ClearCollect(col_ActiveParcels,Filter(col_LandParcels,'Own.FileNumber' = _FileNumber)))
screenshot-web.powerapps.com-2019.07.25-11-04-31.pngInfinity Error

Code behind _DataCounts

Switch(TableID,
3,_FileNumber,
4,First(Filter(_DataCounts,ID = TableID)).DC,
5,First(Filter(_DataCounts,ID = TableID)).DC,
6,First(Filter(_DataCounts,ID = TableID)).DC,
7,First(Filter(_DataCounts,ID = TableID)).DC,
8,First(Filter(_DataCounts,ID = TableID)).DC,
9,First(Filter(_DataCounts,ID = TableID)).DC,
11,First(Filter(_DataCounts,ID = TableID)).DC)

 

Other galleries are one to one with collection

StevenF19
Level: Powered On

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

Yeah this error has broken a critical app for us and we've had to rollback to a previous version which has delayed some new features that we implemented. Hoping this gets fixed ASAP.

NICO2
Level: Powered On

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

This doesn't work for me. Keep giving error with the collection!!


@v-xida-msft wrote:

Hi @dhock ,

Could you please share more details about the Filter you used within your Gallery control?

 

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Have you taken a try to save your SP List records into a Collection, and use the Collection as data source within your app?

 

On your side, please consider save your SP List records into a Collection, then use the Collection as data source in your app instead of the Original SP List data source.

Set the OnStart property of the App control to following:

ClearCollect(RecordsCollection, 'YourSPList')

then set the Items property of the Gallery to following:

RecordsCollection

If the issue still exists, please consider remove the SP list connection from your app, then re-create a new one from your app, then try above solution, check if the issue is solved.

 

Please also consider submit an assisted support ticket for further help through the following link:

https://powerapps.microsoft.com/en-us/support/pro

 

Best regards,



@v-xida-msft wrote:

Hi @dhock ,

Could you please share more details about the Filter you used within your Gallery control?

 

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Have you taken a try to save your SP List records into a Collection, and use the Collection as data source within your app?

 

On your side, please consider save your SP List records into a Collection, then use the Collection as data source in your app instead of the Original SP List data source.

Set the OnStart property of the App control to following:

ClearCollect(RecordsCollection, 'YourSPList')

then set the Items property of the Gallery to following:

RecordsCollection

If the issue still exists, please consider remove the SP list connection from your app, then re-create a new one from your app, then try above solution, check if the issue is solved.

 

Please also consider submit an assisted support ticket for further help through the following link:

https://powerapps.microsoft.com/en-us/support/pro

 

Best regards,



@v-xida-msft wrote:

Hi @dhock ,

Could you please share more details about the Filter you used within your Gallery control?

 

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Have you taken a try to save your SP List records into a Collection, and use the Collection as data source within your app?

 

On your side, please consider save your SP List records into a Collection, then use the Collection as data source in your app instead of the Original SP List data source.

Set the OnStart property of the App control to following:

ClearCollect(RecordsCollection, 'YourSPList')

then set the Items property of the Gallery to following:

RecordsCollection

If the issue still exists, please consider remove the SP list connection from your app, then re-create a new one from your app, then try above solution, check if the issue is solved.

 

Please also consider submit an assisted support ticket for further help through the following link:

https://powerapps.microsoft.com/en-us/support/pro

 

Best regards,


 

murv500
Level: Powered On

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

Absolutely no changes made to my apps.  I'm getting reports of this error as of this morning.

Super User
Super User

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

Change my mind,  it is back for me.  Went away for a while so it is not what I thought.  Is anyone from MS doing anything?

ticotico
Level: Powered On

Re: Request Operation is Invalid. The $top expression "Infinity" is not valid

It happened to me yesterday too.  I cleared out my lists getting ready for an internal demo and BAM.  I cried for a few hours yesterday.


Tyler

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

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