Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
6 years ago

Connecting to Share Point

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

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      MarcUrdang
      Icon for Post Patron rankPost Patron
      6 years ago

      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