Import Excel template to Synapse, populate and push to Teams/Sharepoint

[AbiNyk]

Hi,

I have a Synapse workspace available where i will be querying som data. I would like to populate the data to some excel template files (stored in Teams/Sharepoint) and (re)save the file in another Teams/Sharepoint folder. 

Is it possible to import an excel file to Synapse and push the modified file to another, or is it only possible to import the DATA? 

If not possible, what do you suggest as the best alternative, logic apps?

Best regards 

[FabianSchut · Accepted solution]

Hi @AbiNyk,

I suggest you use a Python Notebook in Synapse and use the sharepoint API to upload files to the sharepoint site.
Here is an example of a Python script to upload an Excel file:
https://stackoverflow.com/questions/70574450/upload-file-to-sharepoint-using-api-postman#answer-7838...

First, you should get the right access token, preferrably with an app registration and access to the sharepoint site. This is how you receive the access token in sharepoint:
https://stackoverflow.com/questions/75795486/how-can-i-get-an-access-token-using-msal-in-python#answ...

[Anonymous]

HI @AbiNyk,

I check the documents and find current you can read data from SharePoint folder and modify these records, but it is hard to write data back to SharePoint from fabric. (it seems like fabric not able to directly integrate and manage the online SharePoint contents)

Copy data from SharePoint Online List - Azure Data Factory & Azure Synapse | Microsoft Learn

Set up your SharePoint folder connection - Microsoft Fabric | Microsoft Learn

For writeback data operations, I'd like to suggest you publish them to azure side and use azure feature to push data to SharePoint side.

Regards,

Xiaoxin Sheng

[AbiNyk]

What do you mean by "azure side and use azure feature " ?

Would I be able to create azure function or logical apps and call them from Synapse Analytics? 

[AbiNyk]

Its not Fabric but Azure Synapse Analytics 

[Anonymous]

Hi @AbiNyk,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

In addition, since your requirement is more related to azure synapse analytics, you can also post this to azure forum to get better support:

Azure Synapse Analytics - Microsoft Community Hub

Regards,

Xiaoxin Sheng

[frithjof_v]

Do you mean Azure Synapse Analytics or Microsoft Fabric?

Does the Excel template just contain columns of data (i.e. table format, similar to a .csv) or is it more customized, i.e. similar to a form consisting of cells spread around the worksheet?

[AbiNyk]

I mean Azure Synapse Analytics .

The excel template contains pictures, sheets and text and the data area is predetermined, e.g. C4- H4 and down. Probably already containing headers. I thought of interacting with the files with Python through notebooks.