Unanswered

Is there a delegable way to ONLY select specific columns?

(0) Share

Report

Posted on by arpost

455

Greetings, all. I'm looking for ways to optimize performance in my Power App and was curious if anyone knows of a way to filter data from a source but ONLY return, say, two columns rather than all of the data? In apps where I need to collect a set of records but there are 100+ records that meet a criteria, it's painfully slow; in SQL, I'd limit my select statement.

I thought one of the ____Columns functions would do the trick (e.g., ShowColumns, DropColumns), but I see online these aren't fully delegable, which is a problem.

Any thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

There is no way to do it directly in Power Apps. But if you invoke a Power Automate flow and retrieve the records there you can limit the columns being returned from SharePoint using a SharePoint view. You can then restrict the columns further using a Data Select action to remove the automatically include system columns. The data set can then be returned to Power Apps using the Response action and captured as a collection.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

From your description, i suggest you use DropColumns ShowColumns you suggested. Delegation would be an issues when you are using formulas with these functions. If it about Dropping and Showing columns, i dont think you would have any challenge.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Please Subscribe to my Youtube Channel

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@arpost

Just to add a little more...

ShowColumns and DropColumns, besides being non-delegable, do not do what most think. If you use ShowsColumns, for example, and specify only 1 column to show, the function will return a table with the one column, BUT, the entire set of columns was, behind the scenes, sent to the app. It was then the function that returned only the specified column from all the columns that were returned. So, many think that using Show and Drop columns will reduce the amount of data transmitted between the app and the cloud, but it does not. It actually only slows down the app by the amount of time that it takes to then process all the columns retrieved and then either show or drop as requested.

Was this reply helpful? Yes No