
Announcements
Hey everyone,
I'm currently working on an app that requires fetching information from an Excel Online file (table) and placing it in a specific column. I need to retrieve this data, remove any duplicates, and display it in a dropdown list.
I'm encountering some issues with Delegation. Does anyone have any insight into how to obtain this information? Does anyone have any insight into how to obtain this information?
I already tried to use Collect, but the Collect get only 2000 rows.
Hi @NATHAN7 ,
This is probably not the answer you want, however if you are using Excel with more than 2,000 rows, I suggest you consider switching to SharePoint or (budget permitting) Dataverse. Excel is a terrible data source for Power Apps with very limited Delegation ability and often inconsistent results.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps