Forum Discussion
Import data from SharePoint List (Excel) attachment
Hi There,
I am writing to request your assistance with a task involving SharePoint and Power Query. I have a SharePoint list called PQattachment that contains various information and attachments, including some Excel files (.xlsx). I would like to import the data from these Excel files into another Excel workbook using Power Query. However, I am not sure how to do this and I would appreciate your guidance.
Could you please provide me with a step-by-step process to accomplish this task? If possible, please include screenshots or links to relevant resources. This would help me a lot in completing my work.
Thank you for your time and support.
Sincerely,
Sanket
Hi SanketSk
For how to connect to a SharePoint List with Power Query in Excel, you can refer to How to get data from SharePoint List with Power Query (exceloffthegrid.com)
For how to extract data from attachments in a SharePoint list and combine them into a big table, you can refer to an old thread: Get and Transform Excel files from SharePoint list - Microsoft Power BI Community
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
Hi SanketSk
For how to connect to a SharePoint List with Power Query in Excel, you can refer to How to get data from SharePoint List with Power Query (exceloffthegrid.com)
For how to extract data from attachments in a SharePoint list and combine them into a big table, you can refer to an old thread: Get and Transform Excel files from SharePoint list - Microsoft Power BI Community
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Hi, with extracting the data and combining it into a big table, I am having trouble with the solution provided. Would you be able to provide an example or show how to do it?