You’re offline. This is a read only version of the page.
124
Hi
I have a Meeting table which is related to Meeting Attendee table (1:N). I want to filter the Meeting table where some user is in the attendee list, for that I filter the Meeting Attendee table and get the parent meeting id and save it in a collection.
Share
ReportClearCollect(colMeetingID,AddColumns(ShowColumns(Filter('Meeting Attendee',Attendee.'Primary Email' = User().Email),Meeting),'Meeting ID',Meeting.ID))
Using the above the above collection then I filter the meeting table as shown below:
Filter(Meetings,ID in colMeetingID)
In the above function I am getting this error when there are more than 500 meetings where I am the attendee.
This is the limit of an HTTP GET request, the question here is that what is so big in your filter clause that is generating such a big GET string.
Hi @ivan_apps
For some users even after applying the filter there are more than 1000 records id in the URI string. Is this a known issue and what is the limit for the URI string?
agree with this - run the App Monitor and do the retrieval where the error occurs. The monitor should have the network request and the underlying query that exceeded the Uri limit.
If PowerApps is putting all 500 meetings in the URI string something would seem off but perhaps try to not display meetings in the past by default? will help the query limit the data rows returned.
click "Monitor" which should open another window and see what is the underlying issue.
All responses (
Answers (
