Forum Discussion
Microsoft Exchange - Excel files with multiple tabs
I'm using Microsoft Exchange to insert attachments from emails that come monthly. Within the attachment, there are multiple tabs. I need to filter to the specific tab I want to be combined each month...
Hi again KNP , thank you so much for your help! Last question, how do I switch the data source for pFileDirectory to point to a Sharepoint folder? I tried replacing the file path with the link and get this error.
The original query...
let
Source = Folder.Files(pFileDirectory),
FilterRows = Table.SelectRows(Source, each Text.Contains(Text.Lower([Name]), "usage report"))
in
FilterRows
You'd need to change the query to use SharePoint.Files not Folder.Files.
There may be some other minor tweaks required but that'll give you a start.