Power Platform Community Forum Thread Details

My organization is a Google environment, we do not use M365 or OneDrive. We have a Google Sheet that would be better as an app with a simple workflow on it for data entry, review, editing, and approval of new entries. I've run into a few issues while determining if it's feasible to use Power Apps to create the app. We already have licenses for the environment, and no ability to hire any developers for any solutions. I'm an old DBA and middleware coder, but out of practice.

My ideal would be to have an app with a form that allows for data entry directly into the live Google Sheet, sends a notification to a reviewer, who can edit (or not if not needed) and mark it as approved for inclusion. For business reasons we need to continue to have an externally accessible sheet so we can export CSVs for use in other processes that cannot be integrated.

I can use a Google Sheets connector, I had to manually enter a sheet ID because it's a shared Sheet.

The sheet has over 750 rows so far and 36 columns. I have never successfully added the data to an app and get an error about exceeding the grid size. I'm new to Power Apps and looking into Collections.

Is this a feasible tool for our needs?

Categories:

Building Power Apps

Hi @LJ-04031858-0,

I am not a Googe Sheets authority (far from it), however "exceeding grid size" usually means pulling too much data at once (hitting connector response size limits) or failing delegation and trying to load everything client-side.

Even without this, your main issues with a data source which Power Apps is not optimised for will be Delegation and/or limits on the amount of data that the connector will retreive/write and this will become more pronounced once the data rows exceed 2,000. Also refreshing after writing may be a problem.

As you have O365 licences for Power Apps, SharePoint is a far better option for data storage - maybe you can sync your sheet with the List/s using Power Automate.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn