Power Platform Community Forum Thread Details

Hi All,

I have a question regarding delegation that came about earlier this week when I made a slight change to my SharePoint data source ("Requests").

The Power App includes a screen with a Radio Button control that is used to filter a Gallery control to show items from the SharePoint list based upon the status. Radio Button choices are "Open" and "Completed". These values tie to a Status column on the SharePoint list.

Previously, this was a Text column called "Req_Status". Thus, I used the following for the Items property of the Gallery control:

*****************

Filter(
Requests,
Req_Status = radioBtnStatus.Selected.Value
),

*****************

Earlier this week, I replaced Req_Status with a new Choice column called Request_Status. The Choice column values are simply "Open" and "Completed", thus they still align with the Radio Button choices in the Gallery screen. Since I'm filtering on a Choice column now, I updated the Items property of the Gallery to the following:

*****************

Filter(
Requests,
Request_Status.Value = radioBtnStatus.Selected.Value
),

*****************

The Gallery control still displays the pertinent items (based upon the Radio button choice equaling "Open" or "Completed") - however, I noticed that if I select the latter, it's capping at 500 items which is the Data Row Limit setting for the app. There's about 550 items in the SharePoint list with a "Completed" status, so the Gallery is no longer pulling a full dataset. When I was filtering off the Text column (Req_Status), I didn't encounter any issues.

Now obviously I can work around this in the interim by simply increasing the Data Row Limit in the App settings. That said, I'm a bit vexed as to why I'm running into this issue if the Filter function is Delegable.

Is there a reason it would behave differently when filtering against a Choice column versus Text? 😖

Thanks in advance for any assistance / guidance you can provide! 😊

Categories:

Building Power Apps