cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Migrated_User

PowerApps must Read (and Read/Write) all SQL Azure database, not only the first 256 records

Submitted by Solution Sage on ‎04-25-2016 11:11 PM


Apparently, PowerApps now have access only to the first 256 records of a Table. This limit should be removed.

 

Yahya shared this idea  · 

Status: Completed

Please review this article, as SQL does support delegation which would provide access to more than 500 records of a table.

 

https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/

 

Thank you,

Audrie

5 Comments (5 New)
Comments
Migrated_User
Solution Sage
Solution Sage
‎04-25-2016 11:12 PM

  • yeah, 256 in a list is ok but need to be able to select which 256 (or 5000 I've read somewhere) records are returned to the app.

Steelman70
Power Participant
Power Participant
‎06-27-2016 07:58 AM

Delegation is now working for Filter and Sort for Azure SQL, this is a major step and resolves a lot of the limitations.

However, we still need to be able to see queries and not just tables.

Please vote for this https://powerusers.microsoft.com/t5/PowerApps-Ideas/PowerApps-must-also-see-SQL-Azure-Queries-not-on...

Anonymous
Not applicable
‎11-15-2016 12:22 PM

You can only get 500 rows imported from Dynamics 365.  Our field agents have far more contacts than that.  The list threshold should be in the thousands or have it so you can scroll pages with a hundred or so a page.

Audrie-MSFT
Power Automate
Power Automate
‎02-10-2017 06:32 PM
Status changed to: Completed

Please review this article, as SQL does support delegation which would provide access to more than 500 records of a table.

 

https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/

 

Thank you,

Audrie

MRCL
Advocate V
Advocate V
‎08-16-2017 02:41 PM

Yes, I can bring the data I need, using filter. But when I patch it, it will only update the rows that are in the first 500 rows of the source table. Please let me know if this should not be happening because I already called suport and they confirmed this is a known limitation. It is the only limitation that is preventing me to use powerapps in most of my apps.