Forum Discussion
Advocate IImport Excel template to Synapse, populate and push to Teams/Sharepoint
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-78380860
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#answer-75800949
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
AbiNykIts not Fabric but Azure Synapse Analytics
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
- 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?