How can we get the modified Date from a file in Sharepoint?

[jmeier]

Hi Guys,

Im trying to see the last modified date in Sharepoint.

But the date is always 01/01/1601.

Im using a Get Children names and after for each children using
“io.Directory.GetLastWriteTime(item)” to get the last modified date.

I think im using the wrong code, can you guys help me?

Thanks and Happy Automations.

[Blesslin (Blesslin Jeba Shiny A)]

Hi Jmieier.

Welcome to the Community!

You can use Currentfile.LastModifiedDate

Thanks
Happy Automation

[ppr (Peter Preuss)]

also have a look here:
office365-get-item-info

[jmeier]

@Blesslin

Currentfile.LastModifiedDate

Hi Blesslin,

I cant get the LastModifiedDate. That part isnt appear to me.

[jmeier]

Hi ppr,

I dont have an aplication ID to use these packages activities.

[Blesslin (Blesslin Jeba Shiny A)]

Can you use “For each file in Folder” activity and try giving currentfile.LastModifiedDate

[ppr (Peter Preuss)]

can you tell us more on how / waht you have used for activites so far.

Also have a look on
File.GetCreationTime(YourFilePath)
File.GetLastWriteTime(YourFilePath)
…

[jmeier]

Hi ppr,

Im seing a certain folder in sharepoint and i want to know if the modified date is bigger than a date i have stored in an asset. If is bigger i want do donwload the file.

But i cant get the modified date.

[jmeier]

Hi,

Already try cant recognize that code.

[Blesslin (Blesslin Jeba Shiny A)]

If its a sharepoint list use camel query

[ppr (Peter Preuss)]

@Blesslin

If its a sharepoint list use camel query

Aggreed to the same. So have a look on the Get List Items activity

[jmeier]

Hi,

Its not a list.

I saw a person who said:

You can access the files through a normal file path (like network share) and get last modified in the same way you would for a local system file.

But doesn t work for me

Can We get the modified Date of a file from Sharepoint? - Help / Studio - UiPath Community Forum

[ppr (Peter Preuss)]

@jmeier

You can access the files through a normal file path (like network share) and get last modified in the same way you would for a local system file.

such scenarios can be achieved (telling similar story) e.g. by instead of accessing Onedrive’s files in the cloud the attached OneDrive folder is used.

[jmeier]

I understand what you mean but I don’t want to use One drive folders in this case.

[ppr (Peter Preuss)]

@jmeier

but I don’t want to use One drive folders in this case

yes, that why it was labeled as similar story

However, where the UiPathTeam.SharePoint.Acitvities do end, you can also crosscheck the SharePoint Rest Api on its capabilities

Also have a look here:

Delete folder older than x days in sharepoint

In order to get properties like the Created Date or Last Modified Date you can use the Get List Items activity on your library. A caml query like the one below will return the properties of all the folders in a SP Library: <Where> <BeginsWith> <FieldRef Name= 'ContentTypeId' /> <Value Type= 'ContentTypeId' >0x0120</Value> </BeginsWith> </Where> You could also use a CAML query which returns all items at a certain path (including your folder), like the one below: <Query><Whe…

[jmeier]

Going to try to do that, but i realy thought there was a simpler method.

Thanks,