cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
silkwire
Helper I
Helper I

Error when filtering SPO List

 

I am trying to filter on an SPO list with this filter:

 

ForAll(iter,
Collect(cAllRequests,
Filter(Requests,'Request ID'>=firstrecord.ID+min, 'Request ID'<firstrecord.ID+max)

 

and am getting the following error:

 

SPO Error.png

 

According to the recent updates to SharePoint delegation, ID columns can only be filtered with '='. Number type columns can be filtered using many other operators, so I am filtering on a Number type column - 'Request ID'.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @silkwire ,

Could you please show more details about the error message with your formula?

 

Based on the screenshot that you mentioned, I think you have faced an error with your formula rather than Delegation warning issue.

 

Based on the formula you provided, I could not find any syntax error with it. Please consider modify your formula as below:

Clear(cAllRequests);
ForAll(
       iter,
       Collect(
                cAllRequests,
                Filter(
                        Filter(Requests,'Request ID' >= firstrecord.ID + min), 
                        'Request ID' < firstrecord.ID + max
                )
       )
)

Note: I assume the min and max are both number value variable in your app.

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
PytByt
Post Prodigy
Post Prodigy

Hi @silkwire 

I don't know if this help, But have you try to use the filter formula this way:

Filter(Requests,'Request ID'>=firstrecord.ID+min && 'Request ID'<firstrecord.ID+max)

Please give it a try and see if this helps.

Regards,

pytbyt

v-xida-msft
Community Support
Community Support

Hi @silkwire ,

Could you please show more details about the error message with your formula?

 

Based on the screenshot that you mentioned, I think you have faced an error with your formula rather than Delegation warning issue.

 

Based on the formula you provided, I could not find any syntax error with it. Please consider modify your formula as below:

Clear(cAllRequests);
ForAll(
       iter,
       Collect(
                cAllRequests,
                Filter(
                        Filter(Requests,'Request ID' >= firstrecord.ID + min), 
                        'Request ID' < firstrecord.ID + max
                )
       )
)

Note: I assume the min and max are both number value variable in your app.

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,217)