Forum Discussion

Laura Sunday's avatar
Laura Sunday
Copper Contributor
Jan 15, 2019

Export to Excel - Change File Type

Due to security restrictions provisioned on our local environment and published through GPO, the SharePoint Export to Excel feature is blocked.  Because our security team feels that downloaded .iqy f...
security
SharePoint Online
Eva Vogel's avatar
Eva Vogel
Iron Contributor
Jan 16, 2019

Hello Laura Sunday!

 

Few minutes I found interesting about exporting Data from Dynamics to Excel. Look at this: https://atinkerersnotebook.com/2017/03/23/using-functions-within-flow-using-the-compose-action/

 

I think, its a nice idea to make a Flow to export a list from SharePoint to Excel. That flow could be triggered within a control (button) on a PowerApp in your sharepoint list.

 

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Flow-from-PowerApps-Getting-the-Variable-Names-Correct/ba-p/170638

Maybe you can realise this as a workaround in your SharePoint.

Greets, Eva.

 

 

  • Laura Sunday's avatar
    Laura Sunday
    Copper Contributor
    Jan 17, 2019

    I love how basic, OOTB processes are now becoming mountain hikes within SPO. :-) PowerApps and Flow are both great resources, just seems like a lot of work and possible ongoing monitoring for a simple task.  Granted, the result is on us for implementing extensive security measures but this seems to be something MS would have considered or push a fix out on.

     

    Thank you so much for the reply and suggestion.  I'll definitely give it a test drive.  

Resources