How can Azure application access the excel file on company Microsoft 365 services site, for example, Teams site.

Li, Zhenzhong 1 Reputation point
2021-04-22T07:16:51.59+00:00

Hello communities,

I am planning to develop and deploy an visulization web application on company Azure, how can the application access existing excel file on Teams site folder?

For example, a python pandas driven application, that I`d really want to use some thing like pd.read_excel().

BR/Li

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,900 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,921 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
601 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ryan Hill 26,241 Reputation points Microsoft Employee
    2021-05-25T22:41:09.53+00:00

    @Li, Zhenzhong , to get started, I would suggest looking at something like logic apps. You can configure a OneDrive for Business connector to pull the file and a custom API connector that will contain your hosted Python code.

    There are numerous prebuilt templates that will allow to you quickly bootstrap your logic app and add or modify the customizations you need to suit your business needs.

    0 comments No comments