Connecting to Share Point

[MarcUrdang]

Hi

Please can you help me understand the following:

I will be sending 3 new files to Share Point every day. I know that 1 and 2 below work .. but how about option 3 .. is this possible?

1. All files in the folder

2. Only the latest file

3. All files with the latest or today's date

thanks 

Marc

[TomMartens]

Hey @MarcUrdang ,

basically this works.

You have to create a filter that either filters the files that have the date of today or equals the maximum date

For this I would create a column that contains the date of the file.

Now you can determine the max value from this column, create an OR filter that checks if the date corresponds either to the max date or to today.

Hopefully, this provides what you are looking for.

Regards,
Tom

[MarcUrdang]

Hi Tom .. hope all well and safe way up north 🙂

I don't think I was clear ... sorry for that .. I am referring to when you 'get data', point to Share Point, or any folder, and then filter which files you want to combine .. the DATE CREATE date seems to be using a differnt setting to the actual date the file was created?

Thanks
Marc