Share via

Use file in Teams/Sharepoint library as a data source for Excel

Anonymous
2024-09-13T15:49:31+00:00

Hello,

I am trying to create a master Excel file of responses from several Microsoft Forms owned by a Microsoft Team/group that I am part of. I'd like to set my master file to automatically pull the data from the Excel files that sync with the Forms. That way the master list will also stay up-to-date as Form responses come in. However, I can't figure out how to find the file through the Get Data function. The Forms sync to an Excel form saved in the Teams/Sharepoint Library. I can find the folders saved under different channels and under "General", but not the Teams/Site library. How can I do this?

Thanks!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-13T17:32:16+00:00

    Dear KT_27, Good day! Thank you for posting to Microsoft Community. I am happy to help you.****Currently, based on my investigation and testing, it is not possible to directly use an Excel file in SharePoint Library as a data source: Import data from data sources (Power Query) - Microsoft SupportFor a workaround, if you are willing, you may firstly sync files from the SharePoint library where the Excel file is saved. （Files in Teams should be saved in the corresponding SharePoint Library） You can click the Sync button from ribbon in the SharePoint library to sync files.In Excel, go to Data tab>Get Data>From File>From Excel workbook, then navigate to the SharePoint sync folder and choose your Excel file > click Import >choose a sheet and click Load to load data.Screenshots and article for your reference:Sync SharePoint and Teams files with your computer (microsoft.com)

    Another way is to extract the data through Power Automate and then export it to a specified location. If you'd like to know how, I'd suggest you head over to this forum and post for help: Microsoft Power Platform Community Forum Thread. The reason I ask you to post a new thread is that in Answers forum, we have limited resources and very little knowledge about Power Automate and in Microsoft Power Automate Community, you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction.Thank you for your cooperation and understanding. Please do not hesitate to post your queries in Microsoft Community and we will always do our best to assist you!Sincerely,Tin | Microsoft Community Moderator

    0 comments