Create a condition and filter all modified files less than one hour

[OfficeKundig]

I try get all files filtered which have been change in the last hour or even better I want to filter the files changed in a sharepoint library. An overview of these files must be emailed to a specific employee.

I tried this:
formatDateTime(triggerBody()?['Modified'],'dd-MMMM') -gt
formatDateTime(utcNow(),'dd-MMMM')

also when changing the -gt to -eg all files existing in this library are emailed to the employee.
Please help me out and tell me the correct expression to use.

kind regards,
Jan
Netherlands

[eric-cheng]

Hi @OfficeKundig 

Try the below expression to get the datetime of an hour ago

@addHours(formatDateTime(utcNow(), 'yyyy-MM-dd hh:mm:ss'),-1)

Pass it into your odata filter (include single quotes)

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn 

[OfficeKundig]

Hi Thanks for this super fast response.

I got it working but still wonder if I can use minutes instead of hours as well?

[eric-cheng]

Hi @OfficeKundig 

Please replace addHours with addMinutes and -1 with -60

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[OfficeKundig]

perfect this is working as well

I notice you know a lot and want to ask you the following question as well:

When in a specific library a file is stored my client asked if it is possible to create a link in a different library to this specific file using power automate.

I and my client will be very grateful when you can answer this question

kind regards and thanks in advance

Jan

[eric-cheng]

Hi @OfficeKundig ,

So you want to create a link to a file in a doc library from a list right?

Is the file existing or will it be created as part of a flow?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[OfficeKundig]

Good morning,

In SharePoint we have library 'A' and a library 'B'

The project team stores a new file in library 'A'

A hyperlink needs to be created in library 'B'

When clicking this hyperlink in library 'B' the new file stored in library 'A' should open

regards,

Jan

[eric-cheng]

Hi @OfficeKundig 

I will post something tomorrow morning.  I am guessing there is a lookup or some type of metadata to link the library and list?

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[OfficeKundig · Accepted solution]

Hi eric,

please do not forget to post the requested solution.

kind regards,

Jan

[OfficeKundig]

?