Power Platform Community Forum Thread Details

I am building a Power App to allow our finance team to export overtime claims from a SharePoint list in the form of a CSV file. The problem is that the number of items will be in the order of 2000 to 3000 and so the solution needs to be delegable. I need to be able to retrieve 8 columns from the list. The items selected need to include only items that fall between a start and end date.

I created a gallery using the values from two date pickers, which set the from and to date range, so that only the items of interest are populated. That works in isolation, but even though the list columns being used for the filter are indexed, I still run into delegation.

I have a flow in Power Automate that uses the get items action, which has Odata filtering on the dates to achieve the same ends, and that processes the list items, then via some select and build table actions, I can create the CSV file. This got me wondering if I can use that flow to send the contents of the get items back to Power Apps, where I can use it in the gallery or a collection. Is that possible?

I'm still relatively new to these tools, so I would value some help to set me on the right course.

Thanks 👍

Categories:

General Questions