You’re offline. This is a read only version of the page.
Announcements
56
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! 😊
Try
Share
Report
All responses (
Answers (
Filter(
Requests, IsBlank(Request_Status.Value)|| // will show all records if a blank is included
Request_Status.Value = "Open"||
Request_Status.Value = "Completed"
),
