Forum Discussion
Bulk files upload from the folder
Hi D3K ,
I'd like to suggest you replace accurate filter part with Text.Contains/Text.StartsWith function to check specific text string:
#1: SelectRow= Table.SelectRows(Source, each [Folder Path]="https://xxxxxxxxxxxxx" and Text.Contains([Name],"Receipt")) #2: SelectRow= Table.SelectRows(Source, each [Folder Path]="https://xxxxxxxxxxxxx" and Text.StartsWith([Name],"Receipt"))
Regards,
Xiaoxin Sheng
Hi D3K ,
I'm not so clear for your scenario, can you please share more details information to help us clarify your requirement?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi Anonymous
Yes, sure. Please, check the situation.
I have the folder with files: stocks, sales and receipts.
When I'm adding this folder as a source, I'm using the filter in Power Query in the next way.
In Query Editor it looks like:
So the question is which code do I need to record into Editor (or use another tools) to make the filter work dynamically: if new file with the text "receipt" in it's name is added - automatically add this file into list of needed files (only files with receipts)?
Thank you for your attention!
Hi D3K ,
I'd like to suggest you replace accurate filter part with Text.Contains/Text.StartsWith function to check specific text string:
#1: SelectRow= Table.SelectRows(Source, each [Folder Path]="https://xxxxxxxxxxxxx" and Text.Contains([Name],"Receipt")) #2: SelectRow= Table.SelectRows(Source, each [Folder Path]="https://xxxxxxxxxxxxx" and Text.StartsWith([Name],"Receipt"))
Regards,
Xiaoxin Sheng