Connect To Sharepoint List Power Query. This doesnt have to be the exact URL to the list the site itself is enough. When you connect using the SharePointFiles function you get a list of all the files in your SharePoint site.
I have another list which contains the complete list of equipment. There is a couple of ways how to connect to the SharePoint file with Power Query but first of all I recommend the connection through SharePoint Folder. This doesnt have to be the exact URL to the list the site itself is enough.
What I would like is to have only 1 table where I add the columns from all the 7 SharePoint lists.
Then write the SharePoint address. With Excel open click the Power Query tab select From Other Sources and the select From SharePoint List. There is a couple of ways how to connect to the SharePoint file with Power Query but first of all I recommend the connection through SharePoint Folder. Well show you two ways to connect to the list depending on whether Power Apps already established a SharePoint connection for you.
