Tip #1417: Power Excel in SharePoint

You’ve seen us in Tip #1415 doing some Microsoft Graph abracadabra to call Excel functions directly from Power Automate. To do that we use Excel spreadsheet located on OneDrive for Business. Documentation mentions in passing that “You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in […]

Tip #883: Exporting filtered lists to Excel from subgrids

In CRM 2013 – Dynamics 365, subgrids do not have the “Export to Excel” button, but you can click the “pop out” button on the subgrid to open the full associated view, from where you can export to Excel. However, what if your subgrid is filtered by a different view? Let’s say you have 20 […]

Tip #860: When export to Excel fails for no reason

Export Excellence Award

Dynamics 365 is a temperamental mistress – everything is fine until it is not. Export to Excel has been working for a customer like a clockwork but then one day, without any warning, attempts to export this view: started to generate this error: (Clicking Show technical details would give some useless generic error with the […]