Power Platform Community Forum Thread Details

Hello, everyone,

I’m working with a model-driven app and have noticed something odd. In the views of the table within the app, both the 'Download Template' and 'Import (Import from Excel)' buttons are available:

However, when I use a subgrid to display another table within a form, the 'Download Template' button is available, but the 'Import (Import from Excel)' button is missing—although I really need it there.

Does anyone know if this is a limitation, or if there’s a way to enable the Import button in subgrids? It doesn’t make much sense to have the option to download the template but not to import it with data.

Thanks in advance!

Categories:

Building Power Apps

Hi,

You’re correct that, by default, subgrids in model-driven apps don’t have the "Import from Excel" button available out-of-the-box (OOB). This limitation means that while you can download the template, there’s no direct import option within subgrids. However, if you want to enable this functionality, you can create a custom solution.

One approach is to build a custom button using Power Automate or a custom script. This custom button can retrieve data from an Excel file and create new records based on that data, effectively mimicking the import functionality in subgrids.

Hope this helps.

Thanks!
Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/