Unanswered

Error in the filter function "The URI string is too long"

(1) Share

Report

Posted on by Usman2

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.

ClearCollect(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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Shashank Bhide 946 Moderator on at

Like (1)

Report
Copy link

Link copied!

click "Monitor" which should open another window and see what is the underlying issue.

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Usman2 124 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Shashank Bhide 946 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No