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