Hi,
I'm trying to build a Power Apps app that allows users to edit data stored in an Excel file using a gallery and a form.
The gallery displays around 6 columns, and users are expected to fill in 3 of them. The Excel file is stored either on OneDrive or SharePoint (whichever is more suitable).
There are two key challenges:
- The gallery needs to be filtered by the user's email so that each user only sees their own data (there is an email column in the file).
- The dataset is relatively large — about 10,000 rows in total, with approximately 200 rows per user.
In my initial approach, I used a standard gallery connected to a form. When a user selects a row, they can fill in 3 fields in the form and click Save.
This setup works partially — the data is correctly updated in the Excel file, but the gallery does not refresh after submission. I tried using the Refresh function etc., but without success.
A colleague suggested using a collection, which solved the refresh issue. However, I then ran into row limit problems in Power Apps.
Is there a better approach for this scenario? Or am I missing something?
I'm relatively new to Power Apps, so I’d really appreciate any guidance or best practices.
