Answered

Dropdown only shows first 500 values from Google Sheet

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a dropdown list in my canvas app, which is pulling values from GoogleSheet, and it's only showing first 500 values from the column.

The column is over 27,000 rows, but that is only because the are a lot of duplicates, which I cannot eliminate, because it's necessary for further dependent dropdown. Instead, I use Distinct(Sort(PhaseCode,Phase),Phase).

Any ideas on why power app only looks at first 500 values in googlesheet?

Thank you,

Yulia

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (2)

Report
Copy link

Link copied!

This is happen because delegable queries is not supported in GoogleSheets. You can raise your limit to 2000 records ( but i think is not enough) from File/Settings/AdvancedSettings - Data row for non-delegable queries

More info:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Was this reply helpful? Yes No
Verified answer

StuartSmith 225 on at

Like (2)

Report
Copy link

Link copied!

Have you tried "File | Settings | Advanced Settings" and changing the "Data row limit" to 2000 (currently that's the max value).

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you! Eventually I will connect dropdown to SQL server database, googlesheet is just for now to work on the front end. Are there limitations for the server?

Thank you!

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

You will find what you need here ...

https://docs.microsoft.com/en-us/connectors/sql/

Was this reply helpful? Yes No